Category Archives: SQL

How to rename instance of SQL Server after a computer rename

For a renamed computer that hosts a default instance of SQL Server, run the following procedures: sp_dropserver <old_name>;GOsp_addserver <new_name>, local;GO Restart the instance of SQL Server. For a renamed computer that hosts a named instance of SQL Server, run the … Continue reading

Posted in SQL | Tagged | Comments Off on How to rename instance of SQL Server after a computer rename