Nice article. I was surprised SQL Server let me place the trigger on that system table. It blocks it for other tables unless you modify the table first.

Keep in mind that any user with access to the DTS packages can delete the various versions and thus destroy a record of what changed.

Its nice to know someone else has databases on each server for DBA use. Ours are referred to as SAResources.

Robert W. Marda

SQL Programmer

bigdough.com

The world’s leading capital markets contact database and software platform.