Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Transact-SQL (2005)  Obtaining windows principal info from SQL login

Author  Topic  AlexH Starting Member 1 Post Posted - 2008-09-08 : 18:13:03 I'm pretty sure I already know the answer to this (which is that it isn't possible) but I want to make sure that's the case as being able to do it would sure make life easier. So I'm working on an ASP.NET application which runs on an Intranet (Active Directory domain), so that all users will be using an authenticated windows identity to connect. However, the application is not connecting to the SQL server with that identity, we're instead using a SQL account which has all the permissions that the application needs. So security is handled by the application and not by SQL server. However, we'd like to set up triggers which, whenever a record in certain tables is updated, it creates an audit record with information about who changed it and when. Problem being that if we're using this one SQL account instead of integrated security, I can't seem to find out the "who" part of the equation. Is there any way to obtain information about the windows account, particularly the username, even though they are connecting to SQL with a SQL account instead of their windows account? Thanks in advance