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