unable to begin a distributed transaction (Msg 7391)

I am receiving the following error when I run a stored procedure:
Server: Msg 7391, Level 16, State 1, Procedure spXXXX

The SP inserts data into a local (sql 2000) table from a remote sql
2000 database. The SP works fine until I add a trigger to the
destination. The contents of the trigger do not appear to matter, as I
have tried removing everything but one line, which is just a declare
statement. Updating the table with the trigger (even the full trigger)
in place does not cause an error. Running the SP without the trigger
on the table does not cause the error.

I have the exact same setup on another server. Both the SP and the
trigger are IDENTICAL. This setup works on one server, but not the
other. The only difference I can see is that the non-working server is
Windows 2000 Server, while the working server is Windows 2003 Server.

Any idea what's going on here?

Thanks in advance.
Eric

.

Relevant Pages

  • Re: Run BAT (or other file) on remotely on server
    ... You haven't told us what OS or web server you're using, ... guessing Windows and IIS. ... Why have to manually trigger regular jobs? ...
    (alt.html)
  • RE: Calling stored procs on AS/400
    ... OK, trigger sounds good. ... > Generally we do not support executing remote stored procedures if linked ... > server is non-SQL Server. ... > Thus the trigger can fire the stored procedure. ...
    (microsoft.public.sqlserver.server)
  • Re: simple server app
    ... Subject: simple server app ... > would like to be able to trigger all exports remotely from the linux ... > running on the windows machine. ... If it's just a bit of data exchange you can use a simple server to accomplish this task, and possibly build your own protocol for data exchange. ...
    (perl.beginners)
  • Re: how to assign the contents of a field to a variable
    ... what happens if the MSMQ server is ... teh requirements of the trigger are to export an XML document to MSMQ ... DECLARE @int_msmqqueue INT ... IF @int_result 0 GOTO ErrorHandler ...
    (microsoft.public.sqlserver.programming)
  • Error beim mit trigger welcher auf einen anderen Server schreibt
    ... eine andere Tabelle auf der selben Datenbank schreibt. ... Auf dieser Tabelle ist ebenfalls ein Trigger, ... einen anderen Server in eine Tabelle schreibt. ... @OwnerLogin varchar, ...
    (microsoft.public.de.sqlserver)