[T-SQL] Change SQL Server instance name

EXEC sp_dropserver 'Old Server Name'

EXEC sp_addserver 'New Server Name','local'

GO

Then restart the SQL service and confirm the new server name with @@SERVERNAME.