Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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 |
|