Toaster Gremlin

Archive for April, 2012

First check the current instance name by running these two queries:

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:

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:

select @@servername
sp_helpserver