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.

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


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.

Jos de Bruijn - SQL Server PM