Archive for April, 2012
First check the current instance name by running these two queries:
1 2 | select @@servername sp_helpserver |
Then to actually change this instance name run the following query. Make sure to update ‘old_instance_name’ and ‘new_instance_name’ accordingly:
1 2 3 4 | sp_dropserver 'old_instance_name' go sp_addserver 'new_instance_name','local' go |
Restart the SQL service in order to apply this change. Then confirm it took effect by running the two queries mentioned above:
1 2 | select @@servername sp_helpserver |