Rudy Rodarte . com

Information

This article was written on 10 Feb 2012, and is filled under SQL Blogs.

Current post is tagged

, , ,

Enable CLR on SQL Server

I ran into a case where CLR was disabled on one of my servers. If you don’t know what CLR is, in a nutshell, you can run VB or C# code on your SQL Server.
Here is a sample CLR procedure from MSDN that calculates sales taxes.
But, back to enabling CLR on your SQL Server. There is a simple command you can use to enable CLR on your SQL Server.

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'clr enabled', 1;
GO
RECONFIGURE;
GO

To check and make sure that CLR is enabled, simply run this select statement:

select  *
from    sys.configurations
where   name = 'clr enabled'

Source: MSDN – Enabling CLR Integration

Rudy

Rudy Rodarte is a SQL Server Database professional based in Austin, TX. Over his career, Rudy has worked with SSRS, SSIS, performance tuning troubleshooting. When away from Keyboard, Rudy goes to Spurs and Baylor Bear sporting events.

More Posts - Website - Twitter

  • Syed Ahsan

    Nice and precise piece of information.