Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Trigger issue Expand / Collapse
Author
Message
Posted Wednesday, February 13, 2013 3:54 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, August 15, 2016 11:09 AM
Points: 112, Visits: 1,004
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
Posted Thursday, February 14, 2013 5:46 AM
SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 9:39 AM
Points: 9,328, Visits: 8,663
That's not much to go on. Do you have any details of it? DDL? Insert statement?


Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1420003
Posted Thursday, February 14, 2013 6:30 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 9:04 AM
Points: 14,458, Visits: 37,969
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

--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Post #1420023
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse