Using SQL Enterprise Manager, you can view information about current server activity. You can view information about current user connections and locks; see the process number, status, locks, and commands that the active users are running; and determine which objects are locked and the kinds of locks that are present. If you have SA privileges, you can also view additional information about a selected process, send a message to a selected user, or terminate a selected process.
For information about monitoring server activity, choose one of the following topics:
Displaying Current Server Activity
SQL Server activity can also be monitored by using the sp_who and sp_lock system stored procedures. For information about these system stored procedures, see the Microsoft SQL Server Transact-SQL Reference.