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.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft