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, and then expand a server.
   
   
2. Expand Management, and 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 Process ID, 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