How to view the last command batch for a connection (Enterprise Manager)

To view the last command batch for a connection

  1. Expand a server group; then expand a server.
  2. Expand Management; then expand Current Activity.
  3. Click Process Info. The current server activity is displayed in the details pane.
  4. In the details pane, right-click a connection (SPID), and then click Properties.
  5. Optionally, click Refresh to update the display.
See Also
Monitoring with SQL Server Enterprise Manager Monitoring with Transact-SQL Statements

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.