Joy Smith San (8/7/2014)

---

Hi All,

App team wants to change the NAME and IP ADDRESS of machine where SQL Server is hosted.

Apart from executing the below script, is there anything else that we need to do ?.

sp_dropserver <old_name>;

GO

sp_addserver <new_name>, local

GO

Thanks,

Joy.