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.

Advertisements

One Response to How to enable CLR in SQL Server 2005

  1. asp.net says:

    asp.net…

    […]How to enable CLR in SQL Server 2005 « Sushantp’s Weblog[…]…

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Who am I what am I doing?

Who am I what am I doing?

%d bloggers like this: