Post reply

copy data using Link server

  • September 22, 2011 at 10:39 pm

    #243626

    we tried to copy data using Link server . But it was giving error that nested transactions not allowed. I was using a stored procedure. Is there a way we can do this? Thank you

  • September 22, 2011 at 10:57 pm

    #1385529

    Is it something like that in the procedure you're using a transaction, and in that transaction you call the procedure again (or another transaction directly)?

    Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2

  • September 23, 2011 at 5:51 am

    #1385633

    Which RDBMS is the Linked server?

    -- Gianluca Sartori

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply