In order to check if command language runtime (CLR) integration feature is enabled within SQL Server, run the following query agaisnt the master database:
SELECT * FROM sys.configurations
WHERE name = ‘clr enabled’
If CLR is enabled the value returned will be ‘1’, as displayed in the ‘value’ row. By default this feature is turned off and the value would be ‘0’.
In order to enable CLR, use the clr enabled option of the sp_configure stored procedure:
sp_configure ‘show advanced options’, 1;
sp_configure ‘clr enabled’, 1;
To disable CLR, set the clr enabled option to ‘0’.