Wednesday, April 30, 2008 #

Enable CLR on SQL Server 2005

Run this query against your SQL Server 2005 to enable CLR on it:

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' , '0';
go

posted @ Wednesday, April 30, 2008 1:21 PM | Feedback (0)