Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

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

0

Assembly execution not allowed on SQL Server.

1

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.

ms175193.note(en-US,SQL.90).gifNote:
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.

ms175193.note(en-US,SQL.90).gifNote:
   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

ADD
Show:
© 2015 Microsoft