INFO: Run Task May Cause 1722 Error

Q140683

The information in this article applies to:

SUMMARY

If a scheduled task is executed immediately with the Run Task button in SQL Enterprise Manager and the @@SERVERNAME variable is not NULL and does not match the Windows NT computer name, the following error will occur:

SQL-DMO Error 1722: Service Control Error


MORE INFORMATION

If the Windows NT computer name is a valid identifier as defined in the SQL Server "Database Developer's Companion," (chapter 4, page 54) change the @@servername variable by running the stored procedure sp_dropserver with the @@servername value and sp_addserver with the computer name and the optional 'LOCAL' parameter.

If the Windows NT computer name is not a valid identifier, change the computer name to a valid SQL Server identifier, and run the sp_addserver stored procedure with the computer name to change the @@servername variable.

Additional query words: sql6 Replication RPC Hyphen winnt comp

Keywords : kbusage
Issue type : kbinfo
Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600


Last Reviewed: March 11, 2000
© 2001 Microsoft Corporation. All rights reserved. Terms of Use.