Jump Start: Enabling the CLR

Jump Start: Enabling the CLR

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'


Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.