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.