Apr 13 2023 10:10 AM
Hello,
I need all sql connections of all users on tables of a database. What options do I have, who has an idea. Thanks
Apr 13 2023 11:52 PM
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.