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.
show processlist; [MySQL]