Tuesday, 12 February 2019

Find CLR enabled or not in SQL Server

Objective:

To find the CLR status in SQL Server.

Query:


SELECT @@servername as Servername, * FROM sys.configurations
WHERE name = 'clr enabled'
go
select * from sys.dm_clr_properties