Export (0) Print
Expand All
Expand Minimize
2 out of 11 rated this helpful - Rate this topic

clr enabled Server Configuration Option

Use the clr enabled option to specify whether user assemblies can be run by 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.

WOW64 servers must be restarted before the changes to this setting will take effect. Restart is not required for other server types.

Note 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 Note

Common language runtime (CLR) execution is not supported under lightweight pooling. Disable one of two options: "clr enabled" or "lightweight pooling. Features that rely upon CLR and that do not work properly in fiber mode include the hierarchy data type, replication, and Policy-Based Management.

The following example first displays the current setting of the clr enabled option and then enables the option by setting the option value to 1. To disable the option, set the value to 0.

EXEC sp_configure 'clr enabled';
EXEC sp_configure 'clr enabled' , '1';
RECONFIGURE;
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.