Awaiting DTC Message: UOW<tranID> -SQL Server 7.0

Question : Are there any enhancements availbale on SQL Server 7.0
regarding this problem ?
What is the solution ?
Is the transaction indoubt?
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright SQLDev.Net 1991-2005 All rights reserved.
<govind.mane@.gmail.com> wrote in message
news:1115987206.147548.70580@.g44g2000cwa.googlegro ups.com...
> Question : Are there any enhancements availbale on SQL Server 7.0
> regarding this problem ?
> What is the solution ?
>

Awaiting DTC Message: UOW<tranID> -SQL Server 7.0

Question : Are there any enhancements availbale on SQL Server 7.0
regarding this problem '
What is the solution ?Is the transaction indoubt?
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2005 All rights reserved.
<govind.mane@.gmail.com> wrote in message
news:1115987206.147548.70580@.g44g2000cwa.googlegroups.com...
> Question : Are there any enhancements availbale on SQL Server 7.0
> regarding this problem '
> What is the solution ?
>

Awaiting DTC Message: UOW<tranID> -SQL Server 7.0

Question : Are there any enhancements availbale on SQL Server 7.0
regarding this problem '
What is the solution ?Is the transaction indoubt?
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright SQLDev.Net 1991-2005 All rights reserved.
<govind.mane@.gmail.com> wrote in message
news:1115987206.147548.70580@.g44g2000cwa.googlegroups.com...
> Question : Are there any enhancements availbale on SQL Server 7.0
> regarding this problem '
> What is the solution ?
>

Avoiding the usage of DTC

Hello

I am running an script and the following sentence throws and error because the DTC service is not running in the Remote Server:

insert into MyLocalTable
execute synonym_MyRemoteProcedure @.SomeParameter

Since a transaction is not declared within the script, why is the DTC required?
How can I avoid the usage of the DTC? Is there a way to say "this code is not within a distributed transaction"?

Thanks a lot.You are still in an explicit transaction. As far as I know, the requirement that the DTC service be running can not be bypassed. You can try using just a select statement to get the data from the remote server, as the "black box" nature of the stored procedure may be causing this.