Hello,

I am getting a lock no wait Conflict.

I know I am supposed to Use a Transaction.

The line of code I want to use is.
SET TRANSACTION WAIT ISOLATION LEVEL READ COMMITTED;
But I dont know where to put it.

Is it in the SP Straight after the BEGIN?
Is it just before the End?

or somewhere In between?

Thank you.

----------

****** Message from InterScan E-Mail VirusWall NT ******

** No virus found in attached file noname.htm
** No virus found in attached file noname.htm

Virus scanned By Foscom Mail Server
***************** End of message ***************



----------

DISCLAIMER:
This email is confidential and intended solely for the use of the individual to whom it is
addressed. Any views or opinions presented are solely those of the author and do not
necessarily represent those of Foscom cc.
If you are not the intended recipient, be advised that you have received this email in
error and that any use, dissemination, forwarding, printing, or copying of this email is
strictly prohibited.
If you have received this email in error please notify Foscom cc. -
by telephone on +27 (0) 11 708-3646, or by return E-mail
We do not accept any responsibility or liability for damage caused by viruses
or any other content contained in this message.



[Non-text portions of this message have been removed]