DECLARE @NumRowsChangedByUpdate int SET @NumRowsChangedByUpdate = (select Count(ProductMaster.ProductKey) from ProductMaster JOIN Inserted on ProductMaster.ProductKey = Inserted.ProductKey join Deleted on ProductMaster.ProductKey = Deleted.ProductKey where Inserted.ListPrice <> Deleted.ListPrice) if @NumRowsChangedByUpdate > 0 -- then go do somethingHowever, if you're using Change Data Capture, you could theoretically tap into something using CDC if you set it up for just a single column, though it's going to involve some work.