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

Changed content:
  • Removed the incorrect statement that this is an advanced option.