The author reorganizes the job by renaming the computer name of the SQLServer job system. This article is as follows: (1) Correct @ servername. Use the following code to directly execute the correction without entering any information. After the execution is complete, the system will automatically shut down. You only need to restart SQLServer. DECLARE @ snsysname, @ snosysname; SELECT @ sncast.
This article is as follows:
(1) fixed @ servername
Use the following code to directly execute the correction without entering any information. After the execution is complete, the system will automatically shut down. You only need to restart SQL Server.
DECLARE @ sn sysname, @ sno sysname; SELECT @ sn = cast (serverproperty ('servername') as sysname), @ sno =servername; IF @ sno is null begin exec sp_addserver @ server = @ sn, @ local = 'local'; SELECT n' Finish the server name to revise, and has already stopped serving, please restart the server '; SELECT n' to complete the server name
