Microsoft KB Archive/156862

= FIX: AV Assigning Decimal from VIEW to OUTPUT Parameter =

Article ID: 156862

Article Last Modified on 10/16/2003

-

APPLIES TO


 * Microsoft SQL Server 6.0 Standard Edition
 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q156862



BUG #: 15623 (Windows NT: 6.0) 15860 (Windows NT: 6.5)



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



WORKAROUND
To work around this problem, do one of the following:


 * Avoid assigning the decimal datatype OUTPUT parameter to a stored procedure.
 * Avoid using views; select directly from the underlying tables.
 * Instead of using OUTPUT parameters, return values from the stored procedure.
 * Create a temporary table to hold the results of the SELECT statement. Then assign the results to OUTPUT parameters, selecting data from the temporary table.



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



MORE INFORMATION
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: kbbug kbfix kbnetwork KB156862

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.