Kevin et. all,

Given a connection pool scenario such as MM connecting to SQL Server, when a user logs on to our application, MM looks for an available connection from the pool and uses that connection.

In this type of scenario, is there any way for the database to know WHO the user is? The username and password for the application is stored in our database and validated upon the user logging on.

I can run the app and then query sysprocesses and see the connections our app is making via the connection pool, but I need to get "currently logged in user info" on the database side.

In certain circumstances in our app, I need to know which user is adding/deleting/updating records for certain tables.

Is this possible in a Connection Pooling environment? I have some ideas but i'm sure there are more possibilites out there that I have not thought of so any feedback from this group would be greatly appreciated.

Thank you for your time...

Scott