Re: transaction isolation level
From: Dan Guzman (guzmanda_at_nospam-online.sbcglobal.net)
Date: 12/15/04
- Next message: Colin Angus Mackay: "Re: Temp Table / Stored Procedure Question"
- Previous message: Tom Moreau: "Re: Trigger and SP"
- In reply to: Andrew J. Kelly: "Re: transaction isolation level"
- Next in thread: Kalen Delaney: "Re: transaction isolation level"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 14 Dec 2004 19:11:03 -0600
Andrew,
IIRC, SET options will revert back to the original settings once the
procedure completes.
-- Hope this helps. Dan Guzman SQL Server MVP "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message news:eEfxY7j4EHA.1524@TK2MSFTNGP09.phx.gbl... > Once you set an isolation level it stays in effect for the rest of that > connection and "Everything" will adhere to it. Actually if you are not > careful and don't set it back you can affect other calls on that > connection as well. One thing to note is that it is very important to > owner qualify your sp calls when they are executed so often. > > exec dbo.yoursp > > > -- > Andrew J. Kelly SQL MVP > > > "ChrisR" <bla@noemail.com> wrote in message > news:OmVdZtj4EHA.2788@TK2MSFTNGP15.phx.gbl... >> Weve got about a dozen or so procs that are run continously. Some as much >> as >> every millisecond. I want to allow dirty reads for these guys. If I "set >> transaction isolation level read uncommitted" at the beginning of the >> proc, >> will that count for every Select..From statement in the proc? Or do I >> need >> to put (read uncommitted) next to every Select ..From in my Proc? >> >> option 1: >> >> ALTER procedure dbo.zzTest >> @ZipCode char(5) >> as >> set transaction isolation level read uncommitted >> >> select bla from bla1 >> inner join bla2 on bla1 ..... >> >> -- >> SQL2K SP3 >> >> TIA, ChrisR >> >> > >
- Next message: Colin Angus Mackay: "Re: Temp Table / Stored Procedure Question"
- Previous message: Tom Moreau: "Re: Trigger and SP"
- In reply to: Andrew J. Kelly: "Re: transaction isolation level"
- Next in thread: Kalen Delaney: "Re: transaction isolation level"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
