• Thanks for pointing out my sever idiocy... I was not paying attention to the code in the book... the SELECT portion of that trigger should have been

    "

    SELECT [ProductID]

    ,[Name]

    ,[ProductNumber]

    ,[MakeFlag]

    ,[FinishedGoodsFlag]

    ,[Color]

    ,[SafetyStockLevel]

    ,[ReorderPoint]

    ,[StandardCost]

    ,[ListPrice]

    ,[Size]

    ,[SizeUnitMeasureCode]

    ,[WeightUnitMeasureCode]

    ,[Weight]

    ,[DaysToManufacture]

    ,[ProductLine]

    ,[Class]

    ,[Style]

    ,[ProductSubcategoryID]

    ,[ProductModelID]

    ,[SellStartDate]

    ,[SellEndDate]

    ,[DiscontinuedDate]

    ,[rowguid]

    ,GetDate()

    ,'I'

    ,USER_NAME()

    FROM INSERTED

    "

    thanks for point out to me that I was not paying attention.

    Have a great day!