In order to make CLR stored procedures run, you must first enable the CLR in SQL Server, other wise you will just get this error:
Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option.
Enabling the CLR is fairly simple, just run this SQL Statement in Query Analyzer, while connected to the database that needs this option enabled:
EXEC sp_configure 'show advanced options' , '1';
reconfigure;
EXEC sp_configure 'clr enabled' , '1' ;
reconfigure;
EXEC sp_configure 'show advanced options' , '0';
reconfigure;
Posted
Oct 26 2008, 08:53 PM
by
dacrowlah