-----------------------------------------------------------

New Message on BDOTNET

-----------------------------------------------------------
From: DIGITAL PIRATE
Message 3 in Discussion

Hi japss,

Try setting transaction isolation level to serializable using the code below
------------
use pubs
set transaction isolation level serializable
------------
Now, test it with few transactions. Doing so can help you identify whether its a 
isolation problem.

NOTE: setting isolation to serializable can hinder performance as locks are frequently 
held on the tables and rows. Though, its not recommended, just do it to identify the 
poblem

Shamir
Goldwire Softweb Pvt. Ltd

-----------------------------------------------------------

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/BDotNet/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the "Remove" link below. On the pre-addressed 
e-mail message that opens, simply click "Send". Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]

Reply via email to