CLR Archives - SQL Authority with Pinal Dave

SQL SERVER – Introduction to CLR – Simple Example of CLR Stored Procedure

October 19, 2008

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

CLR, Software Development, SQL Scripts, SQL Stored Procedure, SQL Utility

CLR is abbreviation of Common Language Runtime. In SQL Server 2005 and later version of it database objects can be created which are created in CLR. Stored Procedures, Functions, Triggers can be coded in CLR. CLR is faster than T-SQL in many cases. CLR is mainly used to accomplish task…

SQL SERVER – 2005 – What is CLR?

March 14, 2008

Pinal Dave

SQL

CLR, SQL Function, SQL Server, SQL Utility

CLR is Common Language Runtime.

Here is the diagram which explains the architecture of the CLR.

SQL SERVER – Fix : Error : Msg 6263, Level 16, State 1, Line 2 Enabling SQL Server 2005 for CLR Support

May 12, 2007

Pinal Dave

SQL

CLR, SQL Advanced Option, SQL Error Messages, SQL Scripts, SQL Server

Error:
Fix : Error : Msg 6263, Level 16, State 1, Line 2 Enabling SQL Server 2005 for CLR Support

1) Enable Server for CLR Support.

SQL SERVER – 2005 Enable CLR using T-SQL script

May 5, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

CLR, SQL Advanced Option, SQL Scripts, SQL Server Security

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;…