ALTER SYSTEM systemName SET OPTIONS ( key 'value' [,...] );
systemName: The name of an existing system.
key ‘value’: One or more key-value pairs, from the following.
NAME: The system name.
HOST: The hostname or IP for the system.
To remove a non-required value, set the value to an empty string (‘ ‘).
Altering a system does not impact any currently connections to the system, but is effective on any new connections initiated after the ALTER SYSTEM command executes.
The system type cannot be changed using ALTER SYSTEM. If it’s necessary to change the system type, drop and re-create the system.
--changing the name of a system, would be SQLSRV5 after the change ALTER SYSTEM SQLSRV1 SET OPTIONS ( NAME 'SQLSRV5' );
--changing the name and hostname/IP of a system ALTER SYSTEM SQLSRV1 SET OPTIONS ( NAME 'SQLSRV5', HOST '127.0.0.1' );
--changing the connection properties option ALTER SYSTEM SQLSRV1 SET OPTIONS ( CONNECTION_PROPERTIES 'ssl=true' );
--unset the option for connection properties ALTER SYSTEM SQLSRV1 SET OPTIONS ( CONNECTION_PROPERTIES '' );