I have software that pulls registry information on software installed on a system, and writes that data into an MS SQL 2000 database. This is, of course a very large database with thousands of systems, and most having between 100 and 400 registry entries. I'm trying to create a table that will log any changes made to the table. I know it must be possible with an UPDATE trigger to compare the deleted and inserted tables. Unfortunately, I don't know much on how triggers work, and don't want to have to compare every entry back and forth to find which ones are new, and which ones are removed.

Does anyone have any hints on how to go about finding what entries are in one table, and not the other?