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.
Syntax for this system stored procedure is:
sp_dropserver <Server Name>
This stored procedure is generally used to rename the server.
