O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

clr enabled

Type: Basic

Default value: 0

SQL Server 2012 supports direct execution of CLR assemblies. It is not optimized to do so; it just supports this capability.

A 0 value for clr enabled indicates that these CLR assemblies are not allowed to run on this SQL Server instance. A value of 1 allows this type of execution. The setting takes effect immediately after sp_configure is run, with no restart of the SQL Server instance required. When RECONFIGURE is run and the run value of the clr enabled option is changed from 1 to 0, all application domains containing user CLR assemblies are immediately unloaded. CLR assembly execution is not supported under lightweight pooling, so you must disable one of two options: clr enabled or lightweight pooling ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required