posted on Wednesday, March 14, 2007 4:45 AM
by
SimonSabin
Using SMO from within SQLCLR
My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Using SMO from within SQLCLR
The new RSS feed is here
SMO is a great feature of SQL Server 2005. It is a rich
API for managing SQL Server and as with its predecssor DMO the SQL Server tools
are built on top of it.
As SMO is a .Net managed library many people want to reference SMO in a SQL
CLR function or stored procedure. However SMO is one library that cannot be
hosted within SQL Server (See Bob's post for more details http://www.sqlskills.com/blogs/bobb/2007/03/13/TwoThingsYouCantDoInSQLCLR.aspx)
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Using SMO from within SQLCLR