What’s New for SQLCLR in SQL Server 2012

Although there are only a few relatively minor changes to SQLCLR support in SQL Server 2012, the technology itself introduces a wealth of potential for developing.NET-integrated SQL Server code that you should consider leveraging in your data-driven applications.

Changes to SQLCLR in SQL Server 2012 include the following:

Image SQLCLR now runs on .NET Framework version 4.0 (earlier SQL Server editions ran version 2.0). You can use the dynamic management view (DMV) sys.dm_clr_properties to query the current version.

SQLCLR objects, however, still always execute within the context of Code Access Security (CAS) ...

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.