Aug 112008
 

By default, CLR is disabled (for security reasons of course), so if you think that writing C# code is easier to call stored procedures compared to actually writing the stored yourself, or otherwise want to extend what SQL Server can do out of the box, you need to enable it.

Here is how you do it:

sp_configure 'clr enabled', 1 go reconfigure go