Microsoft KB Archive/192959

= FIX: SQL Web Assistant Cannot Schedule Page Creation After 1999 =

Article ID: 192959

Article Last Modified on 3/14/2006

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q192959



BUG #: 18153 (SQLBUG_65)



SYMPTOMS
The SQL Server Web Assistant wizard has a Scheduling dialog box. In this dialog box, the year of the Date field is specified by only two digits.

When attempting to set this to a year greater than 99 (for example, 00 or 01), the following warning message appears:

The task cannot be scheduled to run before the current date and time.

You cannot proceed further in the wizard.



WORKAROUND
To work around this problem, execute the Transact-SQL commands directly (for example, use sp_addtask, INSERT MSwebtasks, and sp_makewebtask).

To make this task easier, you might try the following:

 Run SQL Trace and capture the input SQL statements generated by the SQL Server Web Assistant wizard (specifying an acceptable 1999 date). Adjust the trace file by slightly altering this captured input and resubmit it through ISQL/W. To do this, perform the following steps:  Change sp_addtask @name and @procname to something different. Change @activestartdate to the post-1999 you want. Adjust the INSERT MSwebtasks statement to have the name consistent with @name and a unique HTML output file. Alter the @outputfile in sp_makewebtask.</li></ol> </li></ol>

<div class="status_section">

STATUS
Microsoft has confirmed this to be a problem in SQL Server 6.5. This problem has been corrected in Service Pack 5a for Microsoft SQL Server 6.5.For more information, click the following article number to view the article in the Microsoft Knowledge Base:

197177 INF: How to Obtain SQL Server 6.5 Service Pack 5a

For more information, contact your primary support provider.

Additional query words: prodsqlsp sp5Year2000 y2k Year2k y2000

Keywords: kbbug kbfix kbsqlserv650sp5fix KB192959

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.