question

pantonellos avatar image
pantonellos asked

How to get detailed list of connections to database "table"?

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...

tablemssql
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
JohnM avatar image
JohnM answered

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.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.