SQL SERVER Rollback Problems

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Sajan Rajagopal.M (samy_mss_at_rediffmail.com)
Date: 10/09/04 

Date: Sat, 9 Oct 2004 05:06:30 -0700

I have included a query (procedure) inside a begin and
rollback. The Query got Hanged and i stopped the
execution. Upon Stopping the query didnt get rollbacked
instead it got executed and i had lost few data as there
was a delete scripts inside my query.After that i executed
the ROLLBACK alone and it got executed.
Kindly tell me if this is a limitation in SQL server or is
there any patch to be run in order to prevent this. This
is a show stopper in my organisation as all the Back End
Operations are totally dependant on SQL server and if this
case keeps continuing i may have to take precautionary
measures before executing even inside a BEGIN and ROLLBACK
transaction.
Thanking You

Saminathan.S
(Cognizant Technologies Solutions)

Relevant Pages

  • Re: Finally which ORM tool?
    ... Also, if you pass a variable to the query, the value the ... you have a linq query and by changing the variable's value, ... q is affected if I change foo AFTER this query and BEFORE execution. ... And it is a declaration, but one which captures the variables. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Finally which ORM tool?
    ... the session' method. ... able to execute the query by itself. ... has at EXECUTION time is used, ... That SHOULDN'T be important, simply because q LOOKS like a declaration, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Finally which ORM tool?
    ... the session' method. ... they use the same mechanism as Linq to Sql does: ... Also, if you pass a variable to the query, the value the variable ... q is affected if I change foo AFTER this query and BEFORE execution. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: One Insert statement, no looping, creates 2 records?
    ... Is there any chance a distributed query is involved? ... you can see this when the first execution generates the ... >REALLY odd, tho, is that the debug display only shows once, even tho it's ... and the debug display ...
    (microsoft.public.sqlserver.programming)
  • Re: As a generale rule - Query or VBA?
    ... I agree with you Rick, I was recently working on a database that had ... the query is saved, then JET will save the fastest execution path. ...
    (comp.databases.ms-access)