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
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