sp_dropserver

sp_dropserver is a system stored procedure which is used to drop a server from a sql server.

Syntax for this system stored procedure is:

sp_dropserver <Server Name>

This stored procedure is generally used to rename the server.