Lowell,

I get the following error:

Msg 207, Level 16, State 1, Procedure TR_PrmMilkVisitExample1, Line 20

Invalid column name 'LacId'.

Msg 207, Level 16, State 1, Procedure TR_PrmMilkVisitExample1, Line 20

Invalid column name 'LacId'.

When trying your first example.... These are 2 different tables not joined by any keys... PrmMilkVisit and RemLaction are different tables and I only want to run the script when there is a change to the RemLactation table for the columns dryoffdate or calvingdate.