How to Enable CLR in SQL Server 2005

CLR is disable by default in SQL Server 2005. So if you write a SQL assembly and deploy it to your SQL Server 2005. It won't let you execute it.

The SQL Server 2005 Surface Area Configuration let you enable CLR - without having to do it the t-sql way. The tool is under start/All programs/sql server 2005/Configuration Tools. Once in there, you can choose between "Surface Area Config for Services & Connections" or "surface Area Config for Features". Choose Features and you will see the CLR checkbox.

I learned this from Julie Lerman.