Re: transaction isolation level
From: Kalen Delaney (replies_at_public_newsgroups.com)
Date: 12/15/04
- Next message: Aaron [SQL Server MVP]: "Re: Is having dbo as the owner for all application objects a good prac"
- Previous message: Tom Moreau: "Re: SP with RETURN @@IDENTITY returning 0??"
- In reply to: Andrew J. Kelly: "Re: transaction isolation level"
- Next in thread: Andrew J. Kelly: "Re: transaction isolation level"
- Reply: Andrew J. Kelly: "Re: transaction isolation level"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 14 Dec 2004 18:58:36 -0800
Hi Andy
SET options within a stored procedure only are in effect for the execution
of the procedure.
-- HTH ---------------- Kalen Delaney SQL Server MVP www.SolidQualityLearning.com "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: Aaron [SQL Server MVP]: "Re: Is having dbo as the owner for all application objects a good prac"
- Previous message: Tom Moreau: "Re: SP with RETURN @@IDENTITY returning 0??"
- In reply to: Andrew J. Kelly: "Re: transaction isolation level"
- Next in thread: Andrew J. Kelly: "Re: transaction isolation level"
- Reply: Andrew J. Kelly: "Re: transaction isolation level"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
Loading
