Process Details

SQL Server Enterprise Manager Help

SQL Server Enterprise Manager Help

Process Details

Use this dialog box to view or specify the following options.

Options

Last T-SQL command batch

View the first 255 bytes of text of the Transact-SQL statement that was executed by the selected process.

Send message

Send a message to a connected computer or user. For example, you can send a message to connected users notifying them that the server will be shut down for maintenance. The users can then exit their operations and log off the server in anticipation of the server shutdown.

Kill Process

End a process without a forewarnedexit. Use this when a nonsystem process cannot be stopped in any other way. You must be a member of the sysadmin role to terminate processes.

Refresh

Perform a new query against the server and repaint the window to get an accurate depiction of the current activity.

See Also

Monitoring with SQL Server Enterprise Manager