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 |
|
scholes
Starting Member
4 Posts |
 Posted - 2005-10-14 : 04:15:23
|
| have a client server application running,the client machine connects to SQL server 2000 on the server via mixed mode authentication. So the user at the client machine, runs the client part of the application, which then connects to the server. Now, a table in the database has a trigger which fires when an update is done to this table. this trigger records information of who(made the change) and what was changed in the table. This app connects to the server and database via a System DSN odbc connection, which uses NT authentication(network login id).What i want do is to to get the name of the user who has logged into the client machine. The users log in with their domain usernames eg: S2\Fayyaz.Asmalnow in my trigger, if i use SYSTEM_USER or any of the other functions(USER_ID, suser_name etc etc), then i do not get the name of the user logged in at the client, instead i get NT AUTHORITY\SYSTEM. But i want the domain user name of person logged in. CAN ANYBODY HELP ME? |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Get domain login of client machine