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 |
|---|---|
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.
Note
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.
Note
Common language runtime (CLR) execution is not supported under lightweight pooling. Disable one of two options: "clr enabled" or "lightweight pooling.
See Also
Concepts
Setting Server Configuration Options
lightweight pooling Option
Other Resources
RECONFIGURE (Transact-SQL)
sp_configure (Transact-SQL)
Help and Information
Getting SQL Server 2005 Assistance
Change History
| Release | History |
|---|---|
14 April 2006 |
|