Sql server help

[Basel]

i have a DB work on access i convert this DB to sql sever. I need to make a log file that save the nt user name and the ip adress of his Pc for each transaction he did.and i need it to be done by a triger on all the tables .Plese help me in that.

 

[williamu]

You can use the SUSER_SNAME macro to get the User Name and the HOST_NAME macro to get the machine ID.


HTH

William
Software Engineer
ICQ No. 56047340

 

[baselbj]

I try this but it give me the name that he use to login in the SQL Server and this will not help me becuse all the system user use the same login name and password to logon sql so i need to know there NT user name that they use to logon the network .
plzzzzzzzzzzz help me asap if there is any solution

 

[williamu]

Sorry :-(, I can't help you anymore on this one as I don't know enough about SQL Server. However, I've no doubt that someone in here will know the answer.



William
Software Engineer
ICQ No. 56047340

 

[baselbj]

thank u William very much

 

[justinmarkham]

Have you tried setting up an NT group and setting the permissions in SQL server the same as the SQL login then tell your users to login via NT authentication instead of using SQL the SQL login.

The best way to get them to do this is then to deny the permissions to the SQL login.

 

[justinmarkham]

Have you tried setting up an NT group and setting the permissions in SQL server the same as the SQL login then tell your users to login via NT authentication instead of using SQL the SQL login.

The best way to get them to do this is then to deny the permissions to the SQL login.

Regards,

Justin

 

[justinmarkham]

Also try:
SELECt nt_username FROM master..sysprocesses WHERE spid = @@spid