VSLive2005 – Richard Hundhausen – SQL Management Objects (SMO)

VSLive2005 – Richard Hundhausen – SQL Management Objects (SMO)

February 9, 2005 | Conferences, Development, SQL 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.