FIX: AV Assigning Decimal from VIEW to OUTPUT ParameterID: Q156862
|
BUG #: 15623 (Windows NT: 6.0)
15860 (Windows NT: 6.5)
Assigning a decimal value from a VIEW to an OUTPUT parameter of a stored procedure causes a handled access violation (AV). The client reports the AV message on SQL Server version 6.0, and appears to stop responding on SQL Server version 6.5. The errorlog contains the details of the access violation.
To work around this problem, do one of the following:
Microsoft has confirmed this to be a problem in Microsoft SQL Server versions 6.0 and 6.5. This problem has been corrected in U.S. Service Pack 2 for Microsoft SQL Server version 6.5. For more information, contact your primary support provider.
This problem happens only when the decimal value is selected from a view and assigned to an OUTPUT parameter of a stored procedure. The process is terminated by the server. On SQL Server 6.5, the client does not report the error, so it appears to stop responding.
Keywords : kbnetwork SSrvErr_Log SSrvGPF kbbug6.50 kbbug6.00 kbfix6.50.sp2
Version : 6.0 6.5
Platform : WINDOWS
Issue type :
Last Reviewed: April 3, 1999