Sometimes its a necessity to rename a SQL server or SQL server instance. I had to rename it couple of times in my IT career. These are steps that I made. step1 : exec sp_dropserver ‘oldserver’ exec sp_addserver ‘newserver’,’local’ step2 : restart the sql server and check whether below query output is same or not …