Enabling the CLR in the Sql Server 2005

If you want to run a CLR object in Sql Server 2005 (or SqlExpress), note that CLR is disabled by default on Sql Server 2005.  You will need to enable the CLR.  Here are the commands that I used to enable the CLR.

EXEC sp_configure 'show advanced options' , '1';
go
reconfigure;
go
EXEC sp_configure 'clr enabled' , '1'
go
reconfigure;

Enjoy,

Wally