Managed Object Permissions

The first thing to know about managed object permissions is that SQL Server has only blessed a certain group of assemblies usable under each of the three SQL Server permission sets.

Figure 48.2 shows the Add References dialog for a SQL Server project in VS 2010 (a.k.a., SSDT), listing these .NET Framework assemblies. They are the only assemblies (aside from user-created assemblies) that can be referenced in SQL Server projects; however, note that with SQL Server 2012, the list is quite a bit longer than in previous editions. Some notable additions include support for XAML and WPF, LINQ, Windows Workflow, Office Interop, Team Foundation, and SQL Server Reporting Services. Note that this list will not change in SSDT, ...

Get Microsoft® SQL Server 2012 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.