Close

August 9, 2016

CLR – Check if enabled, enable it.. etc – SQL Server

“The common language runtime (CLR) integration feature is off by default, and must be enabled in order to use objects that are implemented using CLR integration. To enable CLR integration, use the clr enabled option of the sp_configure stored procedure in SQL Server Management Studio:”  ….  Microsoft

Essential commands:

–check
SELECT * FROM sys.configurations
WHERE name = ‘clr enabled’

sp_configure ‘show advanced options’, 1;
GO
RECONFIGURE;
GO
–enable it
sp_configure ‘clr enabled’, 1;
GO
RECONFIGURE;
GO

–disable it
sp_configure ‘clr enabled’, 0;
GO
RECONFIGURE;
GO

SELECT * FROM sys.configurations
WHERE name = ‘clr enabled’

Leave a Reply