Home Forums SQL Server 2005 SQL Server Express After insert trigger not firing RE: After insert trigger not firing

  • July 30, 2013 at 10:04 am

    #1637059

    ktager (7/30/2013)

    Lowell,

    thanks, I will update the trigger to use the INSERTED table and retest to see if the trigger fires every time.

    Kevin

    the trigger always fires every time, it's just it might not update the data you expect it to.

    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!