Automating SQL Server with SQL DMO

摘要

There are many occasions in project de-velopment where you want your customers to rake some "secure" actions on your SQL Server. By secure I mean the action that is controlled by your software and where you decide what a particular user can or cannot do. For example, you may allow your customer to take a backup of the database only to a certain folder, such as c:temp. More importantly, you may want to block anyone from accessing your SQL Server while your application is running, even with ISQLW. All these actions are possible using SQL Server Enterprise Manager, but we want to do it ptogrammatically. In other words, we want to automate the SQL Server. That gives us a hint. Whenever you want to automate any Microsoft product, most likely it has an object model that exposes certain interfaces and lets you program those interfaces to our taste. For example, there is an object model for ADO, an object model for MS-DEV, and so on. Similarly, there is an object model for SQL Server, which is called SQL DMO or Distributed Management Objects. SQL DMO is a collection of objects encapsulating Microsoft SQL Server database and replication management.