clr enabled Option

Use the clr enabled option to specify whether user assemblies can be run by Microsoft SQL Server. The clr enabled option provides the following values.

Value Description


Assembly execution not allowed on SQL Server.


Assembly execution allowed on SQL Server.

The setting takes effect immediately after sp_configure is run. No restart of the SQL Server instance is required.


When RECONFIGURE is run and the run value of the clr enabled option is changed from 1 to 0, all application domains containing user assemblies are immediately unloaded.


   Common language runtime (CLR) execution is not supported under lightweight pooling. Disable one of two options: "clr enabled" or "lightweight pooling.

See Also


Setting Server Configuration Options
lightweight pooling Option

Other Resources

sp_configure (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release History

14 April 2006

Changed content:
  • Removed the incorrect statement that this is an advanced option.