FIX: SQL Web Assistant Cannot Schedule Page Creation After 1999

• Microsoft SQL Server version 6.5

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.

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:

1. Run SQL Trace and capture the input SQL statements generated by the SQL Server Web Assistant wizard (specifying an acceptable 1999 date).



2. Adjust the trace file by slightly altering this captured input and resubmit it through ISQL/W. To do this, perform the following steps:



1. Change sp_addtask @name and @procname to something different.



2. Change @activestartdate to the post-1999 you want.



3. Adjust the INSERT MSwebtasks statement to have the name consistent with @name and a unique HTML output file.



4. Alter the @outputfile in sp_makewebtask.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 6.5. This problem has been corrected in U.S. Service Pack 5a for Microsoft SQL Server version 6.5. For information about downloading and installing the latest SQL Server Service Pack, see http://support.microsoft.com/support/sql/.

For more information, contact your primary support provider.

Additional query words: prodsqlsp sp5Year2000 y2k Year2k y2000

Keywords          : SSrvWeb kbbug6.50 kbfix6.50.SP5 
Version           : winnt:6.5
Platform          : winnt 
Issue type        : kbbug 

Last Reviewed: May 4, 1999