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