Executing registered procedures on a server group

You can execute registered procedures on all servers in the server group.

Select a server group, and then select File | Execute Registered Procedure.

Select the servers where you want to execute registered procedurea.

You can select the Options button to set display options for the registered procedures output display format at the bottom of the Server Group Registered Procedure Execution window.

Enter registered procedures in the Registered Procedure Statements field. See Chapter 7, “Registered Procedures” for descriptions of registered procedures.

You can enter and execute multiple registered procedures as a batch.

For example:
```
rp_who
go
rp_server_status
go
```
Click Execute to run the registered procedure on the servers you selected.
Select the server tab at the bottom of the Server Group Registered Procedure Execution window, and then select one of the registered procedures from the list of registered procedures you executed, to view the output of that registered procedure for the server you selected.
Select the Result Set tab at the bottom of the Server Group Registered Procedure Execution window, to view the detailed output for the registered procedure you executed on the server you selected, and then select the Messages tab to view or copy messages generated during the execution of the registered procedure that may help resolve any problems.

If you execute the registered procedure successfully, the Status column for the server at the top of the Server Group Registered Procedure Execution window displays “Successful”.