ROLLBACK a transaction
From: Peter The Spate (anonymous_at_discussions.microsoft.com)
Date: 08/27/04
- Next message: Hugo Kornelis: "Re: Time data type"
- Previous message: simon: "Re: Time data type"
- In reply to: Jeannick: "ROLLBACK a transaction"
- Next in thread: Toby Herring: "Re: ROLLBACK a transaction"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 27 Aug 2004 08:03:07 -0700
Have a look at Isolation Levels, and see which is the best
one for you.
Peter
"I may be drunk, Miss, but in the morning I will be sober
and you will still be ugly. "
Winston Churchill
>-----Original Message-----
>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
>.
>
- Next message: Hugo Kornelis: "Re: Time data type"
- Previous message: simon: "Re: Time data type"
- In reply to: Jeannick: "ROLLBACK a transaction"
- Next in thread: Toby Herring: "Re: ROLLBACK a transaction"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
