Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 4 of 4 total

Fri, Oct 30 2009 4:33 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Is there a list somewhere showing which operations require exclusive access? Roy Lambert
Fri, Oct 30 2009 8:59 AM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Roy, << Is there a list somewhere showing which operations require exclusive access? >> Any operation that modifies the metadata of an object (including its name) requires exclusive access to that object, or its container in the case of columns, constraints, indexes, or triggers. So, any CREATE, ALTER, DROP, or RENAME will require exclusive access. With databases, one additional operation, RESTORE DATABASE, requires exclusive access to the database if you choose to restore the database catalog also. -- Tim Young Elevate Software www.elevatesoft.com
Fri, Oct 30 2009 10:07 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Tim How about IMPORT & EXPORT? Roy Lambert
Tue, Nov 3 2009 7:35 AM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Roy, << How about IMPORT & EXPORT? >> No - export uses a read-lock for consistency, and import uses an internal transaction lock. -- Tim Young Elevate Software www.elevatesoft.com