Hi,


Is there a way of setting the transaction isolation level for a DB
(possibly even at server level). I'd like our reporting DB to be set to
read uncommitted, but I can't see how to do this without changing this
for all procs.


Any ideas?



Thanks
Rick



Richard Wadsworth

Database Administrator

CARCRAFT



E: richard.[Email address protected]

T: 07811 341277

Nixon Street, Rochdale OL11 3JW

www.carcraft.co.uk





This email and any files transmitted with it are strictly confidential. It is for the intended recipient only. If you have received the email in error please notify the author by replying to this email. If you are not the intended recipient you must not disclose, distribute, copy, print or rely on this email in anyway. Any views which are expressed in this e-mail are solely the personal opinion of the author and do not necessarily represent the views of CC Automotive Group Limited. Registered in England and Wales No: 819414. Registered office: Nixon Street, Rochdale, Lancashire OL11 3JW. This footnote also confirms this email message has been swept for the presence of known computer viruses before transmission.

MS Sql Server LazyDBA home page