SQL Server Tutorial: How to use CLR with SQL Server 2012


show more Using CLR with SQL Server 2012 provides you with in-depth training on Business. Taught by Martin Guidry as part of the SQL Server: Triggers, Stored Procedures, and Functions show less
please wait ...

Using CLR with SQL Server 2012

In order to use .NET code in our SQL Server we must first enable CLR Integration. CLR Integration is a default feature, but the default is that it is turned off. So we merely need to turn it on. We will do this by using the sp_configure command. The feature we're interested in configuring is called clr enabled. Notice there is a space in there, no underscore. We want to set that equal to a value of 1, but the syntax here rather than use the equal sign so we use a comma.

So this will reconfigure our server to set clr enabled equal to 1. After issuing a command like that you have to issue another command called RECONFIGURE and that should be all we need. We notice at the bottom it says configuration options clr enabled change from 0 to 1. So in other word, it went from turned off to turn on. So that's the first step. CLR is now enabled for the entire instance of SQL Server. There's no way to turn this on and turn it off for one particular database.

It is a setting that applies to ...

Using CLR with SQL Server 2012
Video duration: 4m 11s 1h 52m Advanced

Viewers:

Using CLR with SQL Server 2012 provides you with in-depth training on Business. Taught by Martin Guidry as part of the SQL Server: Triggers, Stored Procedures, and Functions

Subjects:
Business Developer IT
Software:
SQL Server
Author:
please wait ...