How do I change the computer name stored in the SQL server database?
To change the computer name from SERVER_OLD to SERVER_NEW, proceed as follows:
1. Start the command-line interface, log in to the SQL Server database as the sa user (the password is password), and view the computer name.
osql -U sa -P password
The original computer name SERVER_OLD is displayed.
2. Run the following commands to delete the original computer name SERVER_OLD and add the new computer name SERVER_NEW:
sp_dropserver @server='SERVER_OLD', @droplogins=NULL
sp_addserver @server='SERVER_NEW', @local='local',
3. Restart the SQL Server service.