Knowledge Base

BUG: SEM Encounters Unhandled Exception When Creating New Task

Article ID: 190627

Article Last Modified on 10/3/2003


APPLIES TO


This article was previously published under Q190627
BUG #: 18108 (6.5)

SYMPTOMS

Creating a task in Enterprise Manager encounters unhandled access violation if the Windows NT system date is set between the years 2039 and 2079. A Dr. Watson dialog box appears with the following message:
SQLEW.EXE Exception Access violation...

SQL Enterprise Manager shuts down, but SQL Server is unaffected.

WORKAROUND

To avoid the access violation, use the sp_addtask stored procedure to create the task.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.5.

Additional query words: prodsql

Keywords: kbbug kbpending KB190627