Thursday, May 16, 2013

How to Change the SQL Server Instance Name after Renaming the Windows Host

First to check your Existing Server Name by using -select @@servername
Result-ABC

Second Step-Sp_dropserver 'ABC'

Third Step-sp_Addserver 'Ajay'