SQL Server Admin menu


From the KM menu commands for the Server application instance, the SQL Server Admin menu accesses the following menu commands:

Menu command

Description

Interactive SQL

Enables the user to interactively submit queries to the selected Microsoft SQL Server

Kill Server Process

Kills the SQL Server process associated with the spid entered

Shutdown SQL Server Agent

Stops the SQL Server Agent service

Shutdown SQL Server

This command does not shutdown the SQL Server if the SQL Server Agent is running. If the SQL Server Agent is not running, then this command shuts down the server.

Start SQL Server Agent

This command starts the SQL Server Agent and forces the Microsoft SQL Server to start if it is not already running.

Start SQL Server

Starts the specified server

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC PATROL for Microsoft SQL Server 9.5