we needed to move an sql server… so we looked for space in our virtual environment… there was… but wth? moving is renaming… or isnt it? first it looked like it was, but secondly there were a few problems…
basiclly the sql server instance has the same name as the server… wrong!
sp_dropserver ‘old_name’
GO
sp_addserver ‘new_name’, local
GO
this statements change the instance name… following command returns the current instancename…
select @@SERVERNAME
and thats the history of renaming ms sql servers… funny…