[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.sqlserver.programming

Working fine locally but not link server

Ken

3/8/2007 8:53:00 PM

when I worked on query using transaction such as rollback, save, and,commit
for local database then it works just fine.

however I tried to do same thing for licked server it returened a error
message like below.



Cannot promote the transaction to a distributed transaction because there is
an active save point in this transaction.

Anyone has a ieda???
2 Answers

AlterEgo

3/8/2007 10:07:00 PM

0

Ken,

SQL 2K? Is DTC running?

-- Bill

"Ken" <klee@jeromegroup.com> wrote in message
news:OKV8$NcYHHA.4552@TK2MSFTNGP05.phx.gbl...
> when I worked on query using transaction such as rollback, save,
> and,commit for local database then it works just fine.
>
> however I tried to do same thing for licked server it returened a error
> message like below.
>
>
>
> Cannot promote the transaction to a distributed transaction because there
> is an active save point in this transaction.
>
> Anyone has a ieda???
>
>


Adi Cohn

3/8/2007 10:17:00 PM

0

On Mar 8, 10:52 pm, "Ken" <k...@jeromegroup.com> wrote:
> when I worked on query using transaction such as rollback, save, and,commit
> for local database then it works just fine.
>
> however I tried to do same thing for licked server it returened a error
> message like below.
>
> Cannot promote the transaction to a distributed transaction because there is
> an active save point in this transaction.
>
> Anyone has a ieda???

Not much you can do about it. Books on line states that save points
are not supported in distributed transactions. This is taken from
books on line:

"SAVE TRANSACTION is not supported in distributed transactions
started either explicitly with BEGIN DISTRIBUTED TRANSACTION or
escalated from a local transaction."

Adi