• Team:

    1. I have a SSIS job that backs up the CATALOG table daily ( at 10 PM ).

    What I like to do is before I update the backup table I'd like to compare with yesterdays records and

    make a report of what got changed.

    So then what I am really looking for is some SQL code that will help me compare the values in certain fields.

    Now,I can certainly take care of some of the common fields.

    Ahh! But I need help with the "CONTENTS" field. This is a varbinary field I believe.