PRB: Default Values Not Shown in Input Parameters Dialog BoxLast reviewed: June 26, 1997Article ID: Q156141 |
The information in this article applies to:
SYMPTOMSWhen you execute or debug any stored procedure with default value parameters, the Execute Stored Procedure dialog box does not show the default values.
CAUSEOpen database connectivity (ODBC) and SQL Server do not provide any means to retrieve the default values for a stored procedure.
WORKAROUNDThe default values are correctly passed to the stored procedure when you do not enter explicit values inside the Execute Stored Procedure dialog box.
STATUSMicrosoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available. |
Keywords : kbprg VCEntIss VCEntSQLDebug
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |