Setting Server Configuratio ...


SQL Server 2005 Books Online (November 2008)
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.

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.
Tags :


Community Content

Daniel McAdam
Sample Code

To enable assembly execution:

sp_configure 'clr enabled', 1;
GO
RECONFIGURE;
GO

To disable assembly execution:

sp_configure 'clr enabled', 0;
GO
RECONFIGURE;
GO
Tags :

Page view tracker