Locks all over

DerPaul · Post by **DerPaul** » Thu 25 Jan 2007 03:11

Hi

I'd like to be able to lock the entire database, so noone else would be able to make any changes until I unlocked it.

Does anyone know if this is even possible?
And if, then how?

Tx
Paul

Jackson · Post by **Jackson** » Fri 26 Jan 2007 13:18

Please note that this forum is dedicated to Core Lab SDAC product. If you have a question that does not concern Core Lab products, please refer to other resources.

DerPaul · Post by **DerPaul** » Sat 27 Jan 2007 01:09

Okay, I'll rephrase the question:
tDatabase has the Exclusive-property, that'll lock the entire database.
What is the equivalent in tMsTable?

Regards
Poul

Jackson · Post by **Jackson** » Tue 30 Jan 2007 13:45

SDAC doesn't support such functionality.
You can use the SINGLE_USER database options to сontrol user access to the database.
For more information please see documentation of the ALTER DATABASE statement in MSDN or BOL.