sp_addserver is a system stored procedure which is used to add a server in sql server.
Syntax for sp_addserver is:
sp_addserver is generally used to rename a server.
Syntax for sp_addserver is:
sp_addserver 'Server New Name', 'Actual Server'
