Changes to the SQL Server name

Changes to the SQL Server name

1. Use the SELECT @ @ServerName to see the server name of the current database 2. From the Sys.sysservers table, you can see all of the current server name 3. Use sp_dropserver ' servername ' to remove this server name. 4. Use sp_addserver ' new servername ', ' local ' to re-add the on-premises server to the Server table 5. Query the Sys.sysservers table to check if it has been changed 6. Restart the database service, and the modifications are completed as follows: Select @@ Servernameselect * from Sys.sysserverssp_dropserver ' pc-201002101233\sqlexpress '///red section for current server name sp_addserver ' LOCALHOST ', ' LOCAL '//Red part of the server name to be changed to the other parts of the same direct copy of the past is OK.

Changes to the SQL Server name