How to enable CLR in SQL Server 2005

SQL Server 2k5 has .NET Integration as one of the cool features which enables writing Managed Code for user defined fucntions and then getting those running with SQL Server. SQL Server hosts the in process CLR for executing the user defined functions and referenced assemblies once CLR is enabled for SQL Server.

So lets see how we can do that...

Step1:
We need to use the SQL Server Surface Area Configuration for the same which can be found in your All Pragrams -> SQL Server 2005 as shown below

Step2:
Select Surface Area Configuration for Features from the Wizard

Step3:

Select "CLR Integration" from the left pane. And Check the box for enable CLR to get the required result

Hope this helps in case you want to add your Managed assembly or a function to the SQL Server and finding it not running because of CLR not enabled. Hope this blog will help you solve any such problem.

bye for now.