I am running MS SQL Mgt 2008 SP1. Have a linked server in a stored procedure that I insert records into. When I run each insert statement alone outside of the Stored Procedure including the Linked Server, the insert works fine. When I try to execute the Stored Procedure, I get the following error:
Error...OLE DB provider "SQLNCLI10" for linked server "cis" returned message "No transaction is active.".
Any ideas what is wrong here?