Is there any Extended Stored Procedure or Function that can tell me the NT account logon of a database user if they are logged on the SQL Server with a SQL account. I know it's easy to find this if they have logged on with Windows Authentication.

I know this info can be found in the SQL profiler.

BUT, I need to use this info in a trigger to update/insert a user_id column

Regards

Chris

SYSTEM_USER()

the current user is logged in to Microsoft® SQL Server™ using Windows Authentication, SYSTEM_USER returns the Windows 2000 or Windows NT 4.0 login identification name, for example, DOMAIN\user_login_name. However, if the current user is logged in to SQL Server using SQL Server Authentication, SYSTEM_USER returns the SQL Server login identification name, for example, sa for a user logged in as sa

Thanks for the reply

Unfortunately users are logged in using SQL Server Authentication - with several users sharing one account. However I really need to know which individual has updated/inserted a record into a table. I was hoping there was some way of finding each user's individual NT login.

try using suser_sname()

Jaime E. Maccou

I have just tried a quick test using the SYSTEM_USER() and SUSER_SNAME() functions, once logged on as sa and once using Windows Authentication and my domain account, both functions return the same thing, the user I logged on as, so when logged on as sa they both return 'sa' and when logged on using my domain account they return my domain account name.

Unfortunately I do not have any wonderful suggestions of my own I am just reporting on the suggestions of shahchi1 and Jaime. My only suggestion would be to store the logon information in your front end using an API call and pass this value to all the stored procedures that are used to update tables.

Regards
Owain Williams