Search

Disabling FOREIGN KEY and CHECK Constraints by Michel.priori

Active

1
0
Sign in
 to vote
Type: Suggestion
ID: 780036
Opened: 2/26/2013 8:11:38 AM
Access Restriction: Public
0
Workaround(s)
In a batch is important disable contraints.
When we re-enable contraints, we can choose the check option.

The problem is when you need to run a batch in a production window.
If we disable constraints, it's done for all connections.
Details (expand)

Product Language

English

Category

SQL Engine

Proposed Solution

Can we disable constraints "in a session isolated mode" ?

The simples way is to force no-check option when we re-enable it ;
Perhaps you can do plus ...

Primary Benefit

Improved Performance

Other Benefits

 

Virtualization

 
File Attachments
0 attachments
Sign in to post a comment.
Sign in to post a workaround.
© 2013 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement