SQL Server: How to check if CLR is enabled?

sql sql-server clr
magnattic picture magnattic · Jan 26, 2011 · Viewed 108.5k times · Source

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

Answer

Jason picture Jason · Jan 26, 2011 
SELECT * FROM sys.configurations
WHERE name = 'clr enabled'

Related questions

Size of VARBINARY field in SQL Server 2005

I am trying to determine the size in bytes of the contents in a VARBINARY(MAX) field in SQL Server 2005, using SQL. As I doubt there is native support for this, could it be done using CLR integration? Any ideas …

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More
How do I perform an IF...THEN in an SQL SELECT?

How do I perform an IF...THEN in an SQL SELECT statement? For example: SELECT IF(Obsolete = 'N' OR InStock = 'Y' ? 1 : 0) AS Saleable, * FROM Product

Read More