CLR Integration - What's New
Applies to: SQL Server
The following are new features in CLR integration in SQL Server 2012 (11.x):
In version 4 of the CLR, CLR database objects no longer catch corrupted state exceptions. These exceptions are now caught in the CLR integration hosting layer. These exceptions can still be caught by the CLR database components by setting a code attribute (<legacyCorruptedStateExceptionsPolicy> Element). However, this is not recommended because results are not reliable when a corrupted state exception occurs.
Due to the strict security requirements of SQL Server 2012 (11.x), CLR database components will continue to use the Code Access Security model defined in CLR version 2.0.
In CLR version 4, a format error in a System.TimeSpan value will generate a System.FormatExceptions. Prior to version 4 of the CLR, a format error in a System.TimeSpan value was ignored. Database applications that rely on the behavior prior to version 4 of the CLR should run with a database compatibility level (ALTER DATABASE Compatibility Level) of 100 or lower. For more information, see <TimeSpan_LegacyFormatMode> Element.
Version 4 of the CLR supports Unicode 5.1. Sort operations involving some accent marks and symbols will be improved. Compatibility problems may occur if your application relies on legacy sorting behavior. To enable legacy sorting, the database compatibility level (ALTER DATABASE Compatibility Level) must be set to 100 or lower. To support this, SQL Server 2012 (11.x) will install sort00001000.dll in the .NET Framework 4 directory (C:\Windows\Microsoft.NET\Framework\v4.0.30319). For more information, see <CompatSortNLSVersion> Element.
The following columns have been added to sys.dm_clr_appdomains: total_processor_time_ms, total_allocated_memory_kb, and survived_memory_kb.
Feedback
https://aka.ms/ContentUserFeedback.
Kommer snart: I hele 2024 udfaser vi GitHub-problemer som feedbackmekanisme for indhold og erstatter det med et nyt feedbacksystem. Du kan få flere oplysninger under:Indsend og få vist feedback om