Disabling constraints while updating, concurrency issues? -

» SQL Server » SQL Server Questions » Disabling constraints while updating, concurrency issues?

Disabling constraints while updating, concurrency issues?

Last post 06-29-2008 5:22 PM by phrankbooth. 2 replies.

Page 1 of 1 (3 items)
	Sort Posts: Previous Next

06-28-2008 10:00 AM

phrankbooth
Joined on 06-28-2008
Posts 2

Disabling constraints while updating, concurrency issues?

Reply Contact

I need to disable all constraints on some tables and perform some updates. However I'm not sure if doing that will mess things up for concurent processes that are writing to thos same tables.

How can I lock those tables so that other concurrent stuff is locked out while I perform the changes??

06-29-2008 9:37 AM In reply to

aprato
Joined on 12-01-2007
Greater Boston
Posts 191

Re: Disabling constraints while updating, concurrency issues?

Reply Contact

This sounds a little dubious. What's the business problem you're trying to solve?

06-29-2008 5:22 PM In reply to

phrankbooth
Joined on 06-28-2008
Posts 2

Re: Disabling constraints while updating, concurrency issues?

Reply Contact

Never mind. It sounded dubious to me too. Redesigned.

Page 1 of 1 (3 items)