Checking to see if CLR Integration is enabled for SQL Server

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;
GO
RECONFIGURE;
GO
sp_configure ‘clr enabled’, 1;
GO
RECONFIGURE;
GO

To disable CLR, set the clr enabled option to ‘0’.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s