Configuring & Checking CLR integration in SQL Server

In this blog we see, How to Configure 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:)