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  Development Tools  ASP.NET  Get Windows Credentials Through Web Service

Author  Topic  jd152 Starting Member 1 Post Posted - 2007-02-20 : 04:41:42 This is my first post on this forum, so please bear with me. I have a web service which suplies various wimdows- and web- based applcations with data from a central database. Now I need to implement database auditing on the perticular database where I can see when which user added/deleted/modified data on some of the tables. I can't use triggers, as I can't get the current windows. The only user visible to the database is the user that the web service uses to log into the database. I would now just like to know if there is any way to set some kind of variable during a command's execution to allow the trigger to see which user is using the web service. The web service uses stored procedures to manipulate the data, so I can't implement auditing at the web service level. If anyone has some idea of how I can work around this constraint, I would greatly appreciate it.