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



-
Published Tuesday, May 8, 2007 12:51 PM by simonsabin

Comments

Thursday, February 7, 2008 1:16 AM by sharadov

# re: Using SMO from TSQL

I have tried executing the proc this way:

sp_SQLBits_Scripter_GetObjectScript 'DimProduct'

Get the 'object not found' error.

What am I missing here?

Thanks in advance