INF: Run Task May Cause 1722 Error

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

Last Reviewed: March 23, 1999