If I wanted to keep a record of all the "spUpdateEntity" sprocs that were executed on the database I would have spUpdateEntity log all the parms to a separate table (also with CURRENT_USER and CURRENT_TIMESTAMP columns).

If I wanted to keep an audit trail on the entity, regardless of whether it done by spUpdateEntity, I'd use a trigger to also log to a separate table.

Cheers,

- Mark