Trigger issue

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Trigger issue

Trigger issue

Rate Topic

Display Mode

Topic Options

Author

Message

Admingod

Posted Wednesday, February 13, 2013 3:54 PM

Valued Member

Group: General Forum Members
Last Login: Thursday, May 16, 2013 12:03 PM
Points: 55, Visits: 569

I have trigger on a table and it failed when i insert on a table with below errro message and its SQL Server 2005 version.

Msg 8525, Level 16, State 1, Line 1
Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction.

Thanks

Post #1419764

Ed Wagner

Posted Thursday, February 14, 2013 5:46 AM

SSCommitted

Group: General Forum Members
Last Login: Thursday, May 16, 2013 6:44 AM
Points: 1,856, Visits: 528

That's not much to go on. Do you have any details of it? DDL? Insert statement?

Post #1420003

Lowell

Posted Thursday, February 14, 2013 6:30 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 11:42 AM
Points: 11,633, Visits: 27,705

uggh; looks like you are doing something in a trigger(inserting/updating into another server?) that should be done in a service broker, or a schedule job that would do the same step periodically, or maybe via a stored procedure that is prepared to handle errors on the event.

the error in the trigger would have caused the trigger to rollback with the error, i think, so the data that was supposed to be inserted is gone.

some things should not be done in a trigger.

Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #1420023

« Prev Topic | Next Topic »

Permissions