clr enabled Option
Collapse the table of content
Expand the table of content

clr enabled Option

Updated: 14 April 2006

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.

Release History

14 April 2006

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

Community Additions

© 2015 Microsoft