DBCC CHECKCONSTRAINTS crashes on large constraints definitions - by StefDBA

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 793673 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 7/12/2013 10:09:03 AM
Access Restriction Public

Description



Hi,

In case of large constraints definition, DBCC CHECKCONSTRAINTS crashes.

If you use the SQL Script below, DBCC  works fine before constraints creation and crashes after.

Tested on SQL Server Developer edition version 10.50.4000 and 11.0.3000

Regards,

Stef DBA
Sign in to post a comment.
Posted by StefDBA on 9/3/2013 at 2:40 AM
Hi,

FYI, this can be reproduced on SQL 2014 CTP1 (11.0.9120).

Regards,

Stef
Posted by Microsoft on 7/17/2013 at 9:22 AM
Hello,

Thank you for submitting this feedback. We will be addressing this in the next version of SQL Server.

Thanks,
Ajay.
Senior Program Manager