VSLive2005 - Richard Hundhausen - SQL Management Objects (SMO)

February 9, 2005 • Richard HundhausenConferencesDevelopmentSQL Server

Richard Hundhausen is talking about SQL Management Objects (SMO).  Started on a high note.  Good jokes.  Got the audience interested.

 

High points:

 

 

    • You can capture your clicks, and turn them into a script that can be edited.
 
    • SMO is backward compatible with SQL Server 2000 and 7.0!
 
    • Over 500 classes in SMO, with over 19,000 methods, properties, constructors, fields and events
 
    • Can use What-If to see what would happen if you ran something.  You get the SQL but don't HAVE to get the results of running it.