Pages

Friday, September 20, 2013

SQL SERVER – 2005 Enable CLR using T-SQL script | Journey to SQL Authority with Pinal Dave

Before doing any .Net coding in SQL Server you must enable the CLR. In SQL Server 2005, the CLR is OFF by default. This is done in an effort to limit security vulnerabilities. Following is the script which will enable CLR. EXEC sp_CONFIGURE 'show advanced options' , '1'; GO RECONFIGURE; GO EXEC sp_CONFIGURE 'clr enabled'… Continue Reading...

Source: SQL SERVER – 2005 Enable CLR using T-SQL script | Journey to SQL Authority with Pinal Dave