Re: Transaction Activity......

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Frank (BenFranl1947_at_hotmail.com)
Date: 10/01/04 

Date: Fri, 1 Oct 2004 16:13:00 -0700

I noticed that the data I was reading had uncommitted data at that point of
time. For stored procedure I have added the following statement

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

It started working fine.

But If I replace this stored procedure with SQL statement in the code it
works fine.

Thanks for your analysis and reply.

Frank

"William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message
news:eHmLvDAqEHA.2880@TK2MSFTNGP09.phx.gbl...
> Yup. This means the SP is blocked for one or more reasons and timed out
> waiting for something--probably your locked page. Is it trying to write?
If
> not, then it's being blocked by some other operation.
>
> --
> ____________________________________
> 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:eFyIZg$pEHA.324@TK2MSFTNGP11.phx.gbl...
> > Sahil Thanks for your reply.
> >
> > When I read the data by regular select statements it is reading. I am
> > getting the error message when I try to execute a stored procedure which
> > internally uses select statements.
> >
> > Here is the EXACT error message.
> >
> > "Timeout expired. The timeout period elapsed prior to completion of the
> > operation or the server is not responding"
> >
> > Please advice.
> >
> > Frank
> >
> >
> >
> >
> >
> >
> > "Sahil Malik" <contactmethrumyblog@nospam.com> wrote in message
> > news:uU5sQU$pEHA.800@TK2MSFTNGP14.phx.gbl...
> >> Frank,
> >>
> >> Other apps get readonly access i.e. they can read it but cannot change
> >> it.
> >> If they try changing it, they will wait for CommandTimeOut and then get
a
> >> timeout exception, unless of course ur done before that.
> >>
> >> For a fantastic treatise on Isolation levels, read my book - chapter #9
> > :-)
> >>
> >> - Sahil Malik
> >> You can reach me thru my blog at
> >> http://www.dotnetjunkies.com/weblog/sahilmalik
> >>
> >>
> >>
> >> "Frank" <BenFranl1947@hotmail.com> wrote in message
> >> news:OgBCii%23pEHA.2380@TK2MSFTNGP10.phx.gbl...
> >> > I am using SQL Server 2000 and .Net Frame Work1.1.
> >> >
> >> >
> >> >
> >> > I have implemented the transaction based activity using the following
> >> > syntax.
> >> >
> >> > gtrnSQLDB =
gcnnSQLDB.BeginTransaction(IsolationLevel.ReadUncommitted)
> >> >
> >> > Since I am specifying the transaction level of "ReadUncommitted" and
> >> > in-between BEGIN and ROLLBACK if I call SELECT STATEMENT from some
> >> > other
> >> > application for this particular record, will it be in the queue or
will
> > it
> >> > read the uncommitted data? or to read the uncommitted data do I have
to
> >> use
> >> > additional statement in the SELECT statement?
> >> >
> >> > I appreciate your reply,
> >> >
> >> > Frank
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >>
> >>
> >
> >
>
>

Relevant Pages

  • Re: Transaction Question.....
    ... I noticed that the data I was reading had uncommitted data at that point of ... Frank ... >> when the data is read using a STORED PROCEDURE I am getting the error. ... >> rights. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: IIS hangs when certain SQL submitted
    ... > Have you considered using a stored procedure instead of an ad hoc query? ... But after reading some of the material on your ASPFAQ ...
    (microsoft.public.inetserver.asp.general)
  • Re: SLOW Stored Procedure
    ... Start by allocating a couple of hours to read below, and post back if you after reading the article have further questions: ... However, if I run the contents of the stored procedure in a query window, it ...
    (microsoft.public.sqlserver.programming)
  • Re: Writing Stored procedures to be used by PHP
    ... procedure because a stored procedure won't return a recordset.. ... Normally, I do but I was so confused by the information I was reading, I ... decided I'd go to the forum first. ...
    (comp.lang.php)
  • Re: temp store
    ... want to exit from the stored procedure when your IF EXISTS is true? ... Let me know if you need an example of reading the return value. ... > (select the same time twice). ...
    (microsoft.public.sqlserver.programming)