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.
| Author |
Topic |
|
stevelund
Starting Member
5 Posts |
 Posted - 2008-02-12 : 07:45:56
|
| Hi,I have a third party application which logs into a SQL 2000 database using the 'sa' account. Users of this third party application can then make certain change to the database. I'm wanting to log these changes and who makes them. Is there any way I can get the username of the person running the third party app? The SQL functions such as system_user return 'sa' (being the account used to make the changes). I also know about the host_name() function which would help, but the third party app is run from the same machine for all users (users have a shortcut pointing to a server which runs the app). So this doesn't help to identify users either. Is there any way I could get this info from SQL Server? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-02-12 : 13:24:07
|
| There is no way to get that information since they are using SQL authentication to connect and all from the same server.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
stevelund
Starting Member
5 Posts |
Posted - 2008-02-12 : 17:57:52
|
| Thanks for the response. This was what I thought, but good to have some confirmation from someone else.Thanks again. |
|
|
|
|
|
|
Finding user login information