January 20, 2009 at 5:35 am
Dear All,
I have two SQL SERVER EXPRESS installed on two different servers.Now I want to insert records into a table in one server from the other. when I execute the query it gives me the following error .
"Msg 7391, Level 16, State 2, Procedure 'procedure name', Line 6
The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "SERVER NAME" was unable to begin a distributed transaction."
Both the server's OS is windows xp professional with SP 2.
Pls help...it's very urgent. We can't put both the databases in one server as the second database is not in my control (it's for someother system and we are just integrating our system with that.).
Thanks in advance,
M.V Santhosh Nair.
January 24, 2009 at 12:18 am
You could try using one of the mentioned tools (http://www.karaszi.com/SQLServer/info_generate_script.asp) to transfer the data. I prefer using the Database publishing wizard.
[font="Courier New"]Sankar Reddy | http://SankarReddy.com/[/url][/font]
February 12, 2009 at 6:29 pm
I've never used SQL Server Express so I don't know if this will help. The Distributed Transaction Coordinator (DTC) has to be running on both servers.
Your insert code should look like:
SET XACT_ABORT ON;
(Do your insert)
SET XACT_ABORT OFF;
This may handle your problem.
Todd Fifield
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply