Configuring & Checking CLR integration in SQL Server

Configuring CLR integration

Now we are going to configure the CLR, by enabling it.

Enable Set 1
Disable Set 0

sp_configure 'show advanced options', 1;
GO
RECONFIGURE
;
GO
sp_configure 'clr enabled', 1;
GO
RECONFIGURE
;
GO

Disabling 

sp_configure 'show advanced options', 1;
GO
RECONFIGURE
;
GO
sp_configure 'clr enabled', 0;
GO
RECONFIGURE
;
GO

Check whether the CLR is enabled or not using the below query:

SELECT * FROM sys.configurations WHERE name = 'clr enabled'

Thanks for reading:)
Ebook Download
View all
Learn
View all