December 2013
Intermediate to advanced
1872 pages
153h 31m
English
book
Microsoft® SQL Server 2012 Unleashed
by Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
Content preview from Microsoft® SQL Server 2012 Unleashed
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Developing Managed Objects with Visual Studio 2012
When SQL Server 2012 is installed, it includes Microsoft.SqlServer.Server, the assembly that contains the attributes and other classes needed for SQLCLR (the common acronym for managed code running in SQL Server) programming.
The first step in working with SQLCLR is to enable this feature in SQL Server.
Setting Up the Server for Managed Code Execution
Before you can work with managed database objects, you need to execute the following T-SQL commands in the context of the master database:
sp_configure 'clr enabled', 1RECONFIGUREgo
This step is necessary because SQL Server comes with managed code execution turned off by default.
At this point, you’re ready to create your first SQLCLR project ...