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:
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.
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
