SQL Management Objects

The object model for SQL Server 2005 is the SQL Management Objects or SMO. This model is simple in conception and usage and is based on .NET Framework managed code.

It is the primary tool for developing databases management applications using the .NET framework or the SQL server management studio operations. It replaces the SQL-DMO but supports it. About 150 new classes have been added to it. As a cached object model it allows changes to properties of an object before committing it to the SQL server.

This makes the model flexible and gives better performance. The instantiation of objects has also been optimized. Moreover, this model allows the establishment of multiple root directories for servers on a single collection.

It implements advanced multi phase scripting. Finally the managed computer object simplifies the interface to the WMI and supports WMI monitoring and server configuration.