Blargh!

Change SQL name

Jun 21

SuspenceSQL No Comments

view sql name
select @@servername

Change name

sp_dropserver ‘old_name’
go
sp_addserver ‘new_name’,'local’
go

then restart sql

found info here:

http://coderjournal.com/2008/02/how-to-change-instance-name-of-sql-server/