Re: Transaction Question.....
From: William \(Bill\) Vaughn (billvaRemoveThis_at_nwlink.com)
Date: 10/01/04
- Next message: Steve: "correct way to get count of recs in a sqlsrv tbl?"
- Previous message: William \(Bill\) Vaughn: "Re: Are Close and Dispose on connection objects equivilent?"
- In reply to: Frank: "Re: Transaction Question....."
- Next in thread: Frank: "Re: Transaction Question....."
- Reply: Frank: "Re: Transaction Question....."
- Reply: Frank: "Re: Transaction Question....."
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 1 Oct 2004 14:50:26 -0700
What error are you getting?
-- ____________________________________ William (Bill) Vaughn Author, Mentor, Consultant Microsoft MVP www.betav.com Please reply only to the newsgroup so that others can benefit. This posting is provided "AS IS" with no warranties, and confers no rights. __________________________________ "Frank" <BenFranl1947@hotmail.com> wrote in message news:eXrXrj$pEHA.3540@TK2MSFTNGP11.phx.gbl... > Yes, I noticed that other application can read using SELECT statement. But > when the data is read using a STORED PROCEDURE I am getting the error. Is > there any reason for this? > Thanks, > Frank > > > "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message > news:#ot29$#pEHA.592@TK2MSFTNGP11.phx.gbl... >> Other applications can read the data but not change it. If they try they > are >> blocked for CommandTimeout seconds after which they get a timeout > exception. >> >> -- >> ____________________________________ >> William (Bill) Vaughn >> Author, Mentor, Consultant >> Microsoft MVP >> www.betav.com >> Please reply only to the newsgroup so that others can benefit. >> This posting is provided "AS IS" with no warranties, and confers no > rights. >> __________________________________ >> >> "Frank" <BenFranl1947@hotmail.com> wrote in message >> news:O3qlSz%23pEHA.2380@TK2MSFTNGP10.phx.gbl... >> >I am using SQL Server 2000 and .NetFramework 1.1. >> > >> > Here is my transaction based database implementation >> > >> > gtrnSQLDB = gcnnSQLDB.BeginTransaction(IsolationLevel.ReadUncommitted) >> > >> > >> > >> > Since I am saying ReadUncommited, If any other application tries to > access >> > the data in-between BEGIN and COMMIT. Will it be allowed to read the > data? >> > or will it be in queue so that only when the lock is released by other >> > application will be read? >> > >> > Thanks, >> > >> > Frank >> > >> > >> > >> >> > >
- Next message: Steve: "correct way to get count of recs in a sqlsrv tbl?"
- Previous message: William \(Bill\) Vaughn: "Re: Are Close and Dispose on connection objects equivilent?"
- In reply to: Frank: "Re: Transaction Question....."
- Next in thread: Frank: "Re: Transaction Question....."
- Reply: Frank: "Re: Transaction Question....."
- Reply: Frank: "Re: Transaction Question....."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
