Locking nonlogging tables
The database server does not place page or row locks on a nonlogging table when you use the table within a transaction. However, you can lock nonlogging tables to prevent concurrency problems when other users are modifying a nonlogging table
Use one of the following methods to prevent concurrency problems
when other users are modifying a nonlogging table:
- Lock the table in exclusive mode for the whole transaction.
- Use Repeatable Read isolation level for the whole transaction.
Important: Nonlogging raw tables
are intended for fast loading of data. You should change the table
to STANDARD before you use it in a transaction or modify the data
within it.