CODEDIGEST
Home » FAQs
Search
 

Technologies
 

How to enable "clr enabled" configuration option while testing CLR-Proc in Visual Studio?
Submitted By Gaurav Arora
On 3/6/2009 5:45:39 AM
Tags: Interview Questions,CLR  

CLR integration is a new feature which is released with .Netframework 2.0. This feature provides us a way where we can write C# code which can be then executed in SQL server 2005 and above.

 

In Management studio, you may get the below error message when you try to use the CLR integration feature in SQL server 2005.

 

There is an Error message :

Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option

 

while trying to run CLR-PROC in ManageMent Studio.

 

To resolve the above error, execute the following lines in Management Studio :

sp_configure 'clr enabled', 1
go
reconfigure
go

Recent FAQs
  • View All FAQs..