I know you can retrieve active connections from a specific database, but is there a way to retrieve the same info from a specific table. Info like (IPaddress, hostname, loginame , programName, tablename, timelogin) etc...
asked
How to get detailed list of connections to database "table"?
Natively, no. Not that I'm aware of anyway. If you can control the data access patterns via stored procedures, you could gather some of that information (test thoroughly first). If you are looking for real time, I'm not aware of any tools that offer that either.
18 People are following this question.
