Home Forums SQL Server 2005 SQL Server Newbies Cannot Create - Data Insertion Trigger RE: Cannot Create - Data Insertion Trigger

  • February 1, 2009 at 11:38 am

    #936183

    I do not see your listing for the Production.Product table. Since that is the table that your Trigger is on, then that is the format that the INSERTED table has in that trigger and NOT the format of the Production.ProductHistory table.

    So I assume that the Production.Product table does not have the [Action] or [Username] columns.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]