Strangenut

How to enable CLR Stored procedures on SQL Server 2005 and 2008

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

Comments

SQL Server Blog wrote Writing Your First CLR Stored Procedure
on 10-31-2008 8:15 PM
tutorial on writing CLR stored procedures in sql server 2008 wrote tutorial on writing CLR stored procedures in sql server 2008
on 05-31-2010 10:01 AM

Pingback from  tutorial on writing CLR stored procedures in sql server 2008

Powered by Community Server (Non-Commercial Edition), by Telligent Systems