There are plenty of good responses.  SESSION_USER is one I would add.

We used triggers to add auditing to key tables.  We inherited code from several platforms, and added SESSION_USER.  Since each...

Unions have their place, but I believe they fit in standardized jobs where results are more fixed than variable.

In IT, things vary constantly and your "worth" to a company can...

This is for an application that will exist entirely at a clientn site. Both DB/app will be on the same PC.

A similar requirement may be to have a...