Using SMO from TSQL
If you are desperate to get your hands on the code I
used in the SMO in TSQL demo I did at the usergroup meeting you can download it
now from codeplex.
http://www.codeplex.com/SMOinTSQL
There are 2 projects in there one an SSMS project and one a C# project. Both
can be opened using the TFS in codeplex. Or you can just download the code.
The instructions are non-existent at the moment but I am sure you can figure
it out.
I am going to be posting my demo code to codeplex, if you are interested in
contributing let me know and I will give you rights.
http://www.sqlskills.com/blogs/bobb/2007/03/13/TwoThingsYouCantDoInSQLCLR.aspx
-