Enable CLR SQL Server 2005

Thu, Mar 29, 2007 1-minute read

I cant remember each time I have to turn this on how to do it, so here’s a little blog for myself :)

Solution: Enable the server option ‘clr enabled’

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