December 2013
Intermediate to advanced
1872 pages
153h 31m
English
book
Microsoft® SQL Server 2012 Unleashed
by Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
Content preview from Microsoft® SQL Server 2012 UnleashedBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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 ...