There is an error solution of MSSQL2005 server under the management system of virtual host

The error message is:
"sys.servers cannot find server 'BBB'. Verify that the specified server name is correct. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
Or as follows:
"This cursor does not include the table being modified or cannot be updated through this cursor. "

The reason is that after installing the system, the name of the computer has been changed. The original name is "AAA", and the new computer name is "BBB".
Solutions:

Step 1:
Open SQL Server Management Studio, create a new query:
select * from sys.servers
GO
// the original computer name is available here. Then record it (just copy it)
(for example, the original name was AA)

Step 2:
New query:
sp_dropserver [AAA]
GO
sp_dropserver [BBB]
GO
// delete the original name and the current name.

Step 3:
New query:
sp_addserver [BBB],local
GO

// here is the new server name BBB

Step 4:
New query:
sp_serveroption 'BBB','data access', 'true'
GO
Restart the server and you're done.
Note that the server must be restarted!