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