Page 1 of 1
Locks all over
Posted: Thu 25 Jan 2007 03:11
by DerPaul
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
Posted: Fri 26 Jan 2007 13:18
by Jackson
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.
Locks all over
Posted: Sat 27 Jan 2007 01:09
by DerPaul
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
Posted: Tue 30 Jan 2007 13:45
by Jackson
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.