INF: Run Task May Cause 1722 Error

Last reviewed: April 15, 1997
Article ID: Q140683

The information in this article applies to:

Microsoft SQL Server, version 6.0

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 SSrvDMO SSrvEntMan SSrvGen
Version : 6.0
Platform : WINDOWS
Issue type : kberrmsg

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: April 15, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.