ROLLBACK a transaction

From: Jeannick (Jeannick_at_discussions.microsoft.com)
Date: 08/27/04 

Date: Fri, 27 Aug 2004 07:43:02 -0700

I'm reading records from one database to another database, when something
goes wrong i'm doing a rollback. We have to do a rollback of all the records.
Everything is going well, except that the records are locked untill the
commit.

And when a record is locked we can't do a select in this table whitout
nolock.

Table a with 100 records, 1 of these records is locked
" select * from a " fails.

Is there a solution for this whitout changing the select to "......with
(nolock)"

Thanks in advance

Relevant Pages

  • Re: ROLLBACK a transaction
    ... execute your select query, but it would ignore all non-committed records as ... > I'm reading records from one database to another database, ... We have to do a rollback of all the ... > Is there a solution for this whitout changing the select to "......with ...
    (microsoft.public.sqlserver.programming)
  • ROLLBACK a transaction
    ... >I'm reading records from one database to another ... >goes wrong i'm doing a rollback. ... locked untill the ... >Is there a solution for this whitout changing the select ...
    (microsoft.public.sqlserver.programming)
  • How to reference current record dynamically during select
    ... State table has a foreign key pointing to the [Database] ... (SELECT UserName FROM usergroup (NOLOCK) ...
    (microsoft.public.sqlserver.programming)
  • Re: Fast roll-back
    ... locked will stay locked until the entire rollback is complete. ... If the session is killed or the database is restarted (before ... This means that killing a session (or in your extreme case bouncing ... The Co-operative Oracle Users' FAQ ...
    (comp.databases.oracle.server)
  • Re: just wondering about MSKB 828481
    ... seems to depend on the database being in other than ... > rollback I'll be OK. ... SQL Server doesn't, AFAIK, offer any native method for unravelling ... Steve Foster [SBS MVP] ...
    (microsoft.public.windows.server.sbs)
Loading