SQL Server: How display current connections to a database and/or table?
Is there a stored procedure or UI command that shows the current live connections to a particular database and more importantly to a table (if possible)?
For instance, a list of users and when they connected, and what the connection is doing?
MySQL has something like this called "show processlist." Was wondering if SQL Server had something similar.
For instance, a list of users and when they connected, and what the connection is doing?
MySQL has something like this called "show processlist." Was wondering if SQL Server had something similar.
show processlist; [MySQL]
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.