Posted - 08/13/2013 : 11:12:07
is there way, to find out which client is connecting via Linked Server to a specific database and with specific UserID?
>> audit for select-activity in Database
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.
Edited by - gpc44 on 08/13/2013 14:08:38