Titlebook: Real-World SQL-DMO for SQL Server; Allan Mitchell,Mark Allison Book 2003 Allan Mitchell and Mark Allison 2003 Administration.Database prog

業(yè)余愛好者

打擊

貪心

Viewing and Setting Server-wide Options,the event of disaster recovery, you know exactly how your server was set up because you’ve scripted it all out using your nifty SQL-DMO VBScript, Visual Basic, or C# program (or whatever you want to use).

obligation

Foreshadow

Managing Users of Your Database and Server, In many companies, we’ve found that restricting users’ access to databases involves a significant mindset shift and can be a painful exercise. Data security can often be seen as secondary to users being able to access it, so suddenly removing peoples’ access can be quite a shock to them.

生氣地

Getting Started with SQL-DMO,cult. In this chapter, you’ll skim the surface and start to use SQL-DMO to create objects familiar to anyone using a database. You’ll also tweak those objects to behave in the way you want them to. We give you a gentle introduction to using SQL-DMO to manipulate Microsoft SQL Server objects and data

疲憊的老馬

細(xì)查

Using SQL-DMO with OLE Automation,ve your fingers and the keyboard a workout. In this chapter, we show you how to manipulate the SQL-DMO library using nothing more than good old T-SQL. We won’t deny that in our experience there’s a bit more code involved when you do things in T-SQL, but we think the extra code is well worth it, and

過于光澤

Ingredient

Viewing and Setting Server-wide Options, of which must be managed properly. SQL-DMO really helps in these vast environments to automate your work so that you can sit back and do the interesting stuff instead of fighting fires most of the day. For example, you can script out your server properties for all SQL Servers in the enterprise. In