May 16, 2006 at 9:18 am
Hi,
when i run the following command in Query Analyser it works fine:
insert into Linked_SERVERNAME.db_name.dbo.My_Table
Values (TRD_1,TRD_2,TRD_3)
However, when running the same command from within a Stored Procedure I get the following
Establishing connection to remote server
Server: Msg 7391, Level 16, State 1, Procedure dts_sbi_reprocess, Line 285
The operation could not be performed because the OLE DB provider 'MSDASQL' does not support distributed transactions.
[OLE/DB provider returned message: [Microsoft][ODBC SQL Server Driver]Distributed transaction error]
May 19, 2006 at 8:00 am
This was removed by the editor as SPAM
May 24, 2006 at 5:41 am
May 24, 2006 at 6:49 am
Hi,
I got this sorted and it was because the command was inside a transaction.
I did a work around on this using some IF statements.
Regards,
Eamon
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply