Thursday, April 09, 2009

Rename MSSQL Server name

select @@servername
go
exec sp_dropserver 'CLSQL106'
go
sp_addserver 'CLSQL64', 'local'
go

Restart the server

No comments: