Microsoft KB Archive/140683

{|
 * width="100%"|

INFO: Run Task May Cause 1722 Error

 * }

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

Issue type : kbinfo

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600