[sqr-users] Table locking

["Wright, Rodney" <rwright@therousecompany.com>]

I'm running with SQL Server 2000. In my SQR, I need to read a one-record
table at the beginning of the SQR, and keep the record/table locked
exclusively until the SQR nears completion, at which point I'll update
the table and release the lock. Does any one know how I can accomplish
this?

 

Rod Wright

Senior Applications Specialist

The Rouse Company

410-992-6307
 
The information contained in this transmission is for the sole use of the 
intended recipient(s) and 
may contain confidential and privileged information.  Any unauthorized review, 
use, disclosure
or distribution of this communication is strictly prohibited.  If you have 
received this e-mail in 
error, please contact the sender by reply e-mail and destroy all paper and 
electronic copies of
the original message.
Here was a non admissible message part of 'image/gif' MIME type. It has
been automatically discarded before sending the message to the list.