The information in this article applies to:
SYMPTOMSWhen you create a view using an optimizer hint to force an index and the index is specified by the index name, a query on that view fails with the following error:
CAUSEMicrosoft SQL Server version 6.0 incorrectly interprets the optimizer hint as an index name within a view. WORKAROUNDIn the optimizer hint, specify the index using the index id instead of the index name when you create the view. The index id can be obtained by querying the sysindexes system table. STATUSMicrosoft has confirmed this to be a problem in Microsoft SQL Server version 6.0. This problem was corrected in Service Pack 1 for SQL Server version 6.0. For more information, contact your primary support provider. Additional query words: query plan
Keywords : kbprg SSrvProg SSrvTran_SQL kbbug6.00 kbfix6.00.sp1 |
Last Reviewed: December 14, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |