SQL Server How to check if CLR is enabled

Question

SQL Server 2008 - What is an easy way to check if clr is enabled

User · Accepted Answer

SELECT   FROM sys configurations WHERE name    clr enabled

User · Answer

This is  Jason s answer but with simplified output  SELECT name  CASE WHEN value   1 THEN  YES  ELSE  NO  END AS  Enabled  FROM sys configurations WHERE name    clr enabled    The above returns the following     name          Enabled   -------------------------   clr enabled   YES         Tested on SQL Server 2017

User · Answer

The accepted answer needs a little clarification   The row will be there if CLR is enabled or disabled   Value will be 1 if enabled  or 0 if disabled     I use this script to enable on a server  if the option is disabled   if not exists      SELECT value     FROM sys configurations     WHERE name    clr enabled       and value   1   begin     exec sp configure  configname clr enabled   configvalue 1     reconfigure end

User · Answer

The correct result for me with SQL Server 2017   USE  lt DATABASE gt   EXEC sp configure  clr enabled   1 GO  RECONFIGURE GO EXEC sp configure  clr enabled    -- make sure it took GO  USE  lt DATABASE gt  GO  EXEC sp changedbowner  sa  USE  lt DATABASE gt  GO  ALTER DATABASE  lt DATABASE gt  SET TRUSTWORTHY ON      From An error occurred in the Microsoft  NET Framework while trying to load assembly id 65675

User · Answer

select   from sys configurations where name    clr enabled

User · Answer

Check the config value in the results of sp configure  You can enable CLR by running the following   sp configure  show advanced options   1  GO RECONFIGURE  GO sp configure  clr enabled   1  GO RECONFIGURE  GO   MSDN Article on enabling CLR  MSDN Article on sp configure

[sql] SQL Server: How to check if CLR is enabled?

Examples related to sql

Examples related to sql-server

Examples related to clr