Enable CLR and Unsafe Assemblies SQL Server 2005
Since I can never remember this off the top of my head I figured I would post on my blog.
To enable the use of CLR on SQL Server run the following....
EXEC sp_configure 'show advanced options' , '1';
EXEC sp_configure 'clr enabled' , '1'
-- Turn advanced options back off
EXEC sp_configure 'show advanced options' , '0';
To allow unsafe assemblies to run execute the following code against the database that is hosting the unsafe assembly.
alter database MyDatabase set trustworthy on