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 |
gpc44
Starting Member
35 Posts |
Posted - 2013-08-13 : 11:12:07
|
Hello,is there way, to find out which client is connecting via Linked Server to a specific database and with specific UserID?(UserID?...ClientID?...Date?)>> audit for select-activity in DatabaseBackground:The user no longer exists (Real Employee !! :( , and therefore it must be deleted on the SQL server. However, there are applications in our Companie that have deposited in the connection string with the user password (also odbc-connect and Views).We have a lot of tables in this Database, and we cannot put a Trigger on each table. And if the User sends a "SELECT"-Statement, the Trigger doesn't fire.Thank youBEST REGARDSNicole |
|
djj55
Constraint Violating Yak Guru
352 Posts |
Posted - 2013-08-14 : 08:58:19
|
Look at audit trace. sp_trace_createNot sure if that will get you what you want but it might.djj |
|
|
|
|
|