The uses_native_compilation column incorrect on some triggers - by Bob Beauchemin

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


1
0
Sign in
to vote
ID 811725 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 12/16/2013 3:00:25 PM
Access Restriction Public

Description

In SQL Server 2014 CTP2, doing the following query returns some triggers. Triggers cannot have native compilation.
select * from sys.sql_modules where uses_native_compilation = 1;
Sign in to post a comment.
Posted by Jos de Bruijn [MSFT] on 12/30/2013 at 1:57 PM
Hi Bob,

Thanks very much for bringing this to our attention. We have fixed the issue; triggers will no longer appear as 'uses_native_compilation=1'.
The fix will be in RTM.


Thanks,
Jos de Bruijn - SQL Server PM