hi all, This is for 2012
By running sp_drop server and sp_addserver, I was able to change @@SERVERNAME
But SELECT serverproperty('ServerName') and Select ServerProperty('machinename')
still return the old name.
Is there any way to rename ServerName and machineName, without having to reinstall SQL Server?
(I'm trying to get these values to match the actual Windows server name)
Thanks.