VSLive2005 – Richard Hundhausen – SQL Management Objects (SMO)

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.