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.
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
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.
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.
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.