Developing Managed Objects with Visual Studio 2008

When SQL Server 2008 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 the 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:

image

This step is necessary because SQL Server comes with managed code execution turned off by default.

At this ...

Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.