Posted by c-eric.geil on 04/06/07 12:33

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

• Next in forum: Re: unable to begin a distributed transaction (Msg 7391)
• Prev in forum: Re: select distinct record only if certain column not null
• Thread view: unable to begin a distributed transaction (Msg 7391)

[Reply to this message]