I need all connection of all users on tables

Copper Contributor

Hello,

I need all sql connections of all users on tables of a database. What options do I have, who has an idea. Thanks

 

1 Reply

I need all sql connections of all users on tables of a database

Users connect to a SQL Server and they may change the connection context to a specific database (or not), but they never "connect" to a table. They can query data from a table in several way, from the table directly or over a view or using a stored procedure.

So there is not really a way to get the wanted informations.