Jump Start: Enabling the CLR

If you're getting started with SQL Server 2005 Express and you're trying to use some of the new CLR functionality, you might be surprised to run into several errors when you’re trying to get your new CLR objects deployed. That's because the CLR is disabled by default in both SQL Server 2005 and SQL Server 2005 Express. To get your CLR objects deployed, you first need to enable the CLR support in SQL Server 2005 Express. To do so, you can use either the SQL Server Management Studio Query Editor or the sqlcmd command-line utility to enter the following set of T-SQL commands:

EXEC sp_configure 'clr enabled' , '1'
GO
reconfigure;
GO