Hi Dan,

>Obviously this can be tedious to code, but I hope you get the idea. Duffy is right, if you need auditing capability you might check out his product.

Since we're talking SQL Server here now and NOT VFP, I'll do the SET BLATANT MARKETING ON thing again and mention that SQLAudit 2.0 from Red Matrix Technologies (www.redmatrix.com, a company I'm associated with) will automatically generate all of the SQL Server trigger auditing code required to quickly and easily add auditing to a SQL Server database.

SET BLATANT MARKETING OFF... < s >