How to Manually Enable CLR on SQL Server

[sajugovind]

What is SQL CLR  ?

SQL CLR or SQLCLR (SQL Common Language Runtime) is technology for hosting of the Microsoft .NET common language runtime engine within SQL Server. The SQLCLR allows managed code to be hosted by, and run in, the Microsoft SQL Server environment.

To enable CLR

On the Windows desktop, click Start, click All Programs, click Microsoft SQL Server 2008 R2, or Microsoft SQL Server 2008, and then click SQL Server Management Studio.

In the Connect to Server dialog box, follow these steps:

       In the Server Type list, select Database Engine.

       In the Server Name list, select the server name for your Service Manager database.

       In the Authentication list, select Windows Authentication, and then click Connect.

In the Microsoft SQL Server Management Studio toolbar, click New Query.

Type the following in the SQLQuery pane.

Code: [Select]

sp_configure @configname=clr_enabled, @configvalue=1
GO
RECONFIGURE
GO
Press F5 to execute this script.

In the Messages pane, observe that Configuration option 'clr' enabled is displayed.

Thank you,