Database Replication

Posted by Sahoomanoj27 under Sql Server on 1/25/2012 | Points: 10 | Views : 1294 | Status : [Member] | Replies : 0
Hi All,

i am facing one big problem regarding Database replication. The Database Replication is that uploading the data from one local server to another remote server.
here is the description

I am accessing data from my own local server. after 15-20 days i have to upload data from local server to remote server and this procedure is a cycle.

the sql statement i have written is

Insert into OPENROWSET('MSDASQL',
'DRIVER={SQL Server};SERVER=[SERVER NAME];UID=sa;PWD=[PASSWORD]',
DATABASENAME.dbo.TABLENAME) select * FROM TABLENAME


if i am writing this sql statement inside a procedure inside the
Begin Transaction


End

block it throws me a error.

the error is

OLE DB provider "SQLNCLI10" for linked server "[LINK SERVER NAME]" returned message "No transaction is active.".


Please Help Me .

Any help is highly appriciated.

Thank You
MAnoj Sahoo




Responses

(No response found.)

Login to post response