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 >
Jim Duffy
Microsoft MVP
INETA Speaker
TakeNote TechnologiesDeveloper's Choice Award Winner for Best Training Company
Specializing in VB.NET, ASP.NET, VFP, and SQL Server Training and Development