Previously in CF5, we would pass the persons username in the connectstring
attribute of cfquery. Then using SQL Profiler for MS SQL Server, we could look
at the ApplicationName and see who is currently using the database. This would
allow us to only have one userid on the SQL server, but still be able to track
multiple people.

In CFMX is there any way to update the ApplicationName field each time a query
is run?