Blog Stats
  • Posts - 34
  • Articles - 1
  • Comments - 3
  • Trackbacks - 6

 

Enable CLR in SQL Server 2005

I am just started my journey in SQL Server 2005, and for a while I'm stuck because CLR is disable by default in my SQL Server 2005. Then I found this in google to enable CLR in SQL Server 2005:

EXEC sp_configure 'show advanced options' , '1';

go

reconfigure;

go

EXEC sp_configure 'clr enabled' , '1'

go

reconfigure;

-- Turn advanced options back off

EXEC sp_configure 'show advanced options' , '1';

go

From here, we can create User Define Types (UDF), User Define Function (UDF), Table value Functions (TVF), Triggers, and Stored Procedures using programming language such as VB.NET or C# and deploy it to our SQl Server.


Feedback

# re: Enable CLR in SQL Server 2005

Gravatar FYI - the SQL Server 2005 Surface Area Configuration let's you do this also - without having to do it the t-sql way. The tool is under start/All programs/sql server 2005/Configuration Tools. Once in there, you can choose between "Surface Area Config for Services & Connections" or "surface Area Config for Features". Choose Features and you will see the CLR checkbox. 11/18/2005 12:48 PM | Julie Lerman

# Clr Stored Procedures in Sql 2005

Gravatar <br />Using Clr Stored Procedures in Sql Server 2005 <br />For this example you'll need adventure works database installed on your sql server instance AND you'll want a connection in your server pane of Visual Studio.(you can get adventure works database on ... 4/28/2007 12:54 PM | James Peckham

# re: Enable CLR in SQL Server 2005

Gravatar To Turn advanced options back off

The last parameter is 0 instead of 1,as follows

EXEC sp_configure 'show advanced options' , '0';
4/20/2009 1:25 AM | Sushil Jinder

Post a comment





 

 

 

Copyright © Rasyadi