People have asked me several times on CLR enabling the SQL Server 2005. So first of all CLR is not enabled by default on SQL Server 2005 and to enable it you have issue following command on SQL prompt.

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

The sp_configure displays the global configuration for the current server. Where the reconfigure updates the configured value of a configuration option in this case with sp_configure. In our case clr enabled is the parameter to pass to the sp_configure.

Happy Enabling.