Home Dashboard Directory Help
Search

DBCC CHECKCONSTRAINTS crashes on large constraints definitions by StefDBA


Status: 

Active


1
0
Sign in
to vote
Type: Bug
ID: 793673
Opened: 7/12/2013 10:09:03 AM
Access Restriction: Public
1
Workaround(s)
view
0
User(s) can reproduce this bug

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
Details
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
Sign in to post a workaround.
Posted by StefDBA on 7/12/2013 at 10:39 AM
Use a function as described in the original file submitted
File Name Submitted By Submitted On File Size  
ConstraintError.sql 7/12/2013 3 KB