FIX: WAITFOR Variable in Stored Proc May Cause Handled AV

ID: Q142935

The information in this article applies to:

Microsoft SQL Server version 6.0

BUG# NT: 12516 (6.00)

SYMPTOMS

Using the WAITFOR command in a stored procedure where the delay is specified as a DATETIME variable may cause a handled access violation.

CAUSE

Using a variable with the WAITFOR command in this manner is not defined in the SQL Server documentation. However, the same command and variable used outside a stored procedure works fine.

WORKAROUND

Parse the command into a string and use the EXEC facility to implement the WAITFOR.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.0. This problem has been corrected in U.S. Service Pack 3 for Microsoft SQL Server version 6.0. For more information, contact your primary support provider.

Additional query words: SQL6 WAITFOR DATETIME VARIABLE


Keywords          : kbprg SSrvStProc kbbug6.00 kbfix6.00.sp3 
Version           : 6.0
Platform          : WINDOWS 
Issue type        :

Last Reviewed: March 24, 1999