Wednesday, March 28, 2012

linked server problem

linked to a remote server (sql 2000) using sp_addlinkedserver

when i tried to insert data in a table in the remote server it is throwing the following error.
i used transaction in the query.

The operation could not be performed because OLE DB

provider "SQLNCLI" for linked server "server1" was unable to begin a

distributed transaction. - Export Operation Failed

please find me way

thx in advance..
Let's try the data access forum.sql

No comments:

Post a Comment