Double entries

  • Hi. I have a trigger that adds a row to a table whenever another table has a row added or updated.  It seems that the trigger is adding two rows instead of one whenever it's fired.  Anyone ever have this problem? Solutions?  Thanks in advance.

  • Can you post the code?

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • Can you post the code for the trigger. Also, make sure that you do not have another trigger on the table that gets written to.

  • You were right, Tobi.  There was another trigger on the table that was being written to.  This forum is wonderful!

  • Outstanding!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply