The information in this article applies to:
BUG#: 11400 (6.00) SYMPTOMSWhen multiple (50 or more) clients repeatedly run a stored procedure that creates temporary tables and then insert and select from these temporary tables against a quad-processor SQL Server simultaneously, SQL Server can randomly generate errors #208( Invalid object name '%.*s'.) and #267(Object '%.*s' cannot be found.). WORKAROUNDCreate a temporary table outside the stored procedure if the stored procedure is designed to be called by multiple users simultaneously and repeatedly. Only perform truncate, insert, and select commands inside the stored procedure. STATUSMicrosoft 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. MORE INFORMATIONThese error messages are received at the client side, and can be trapped and simply handled by performing retry. This can not be reproduced on a single processor computer, and can rarely be reproduced on a dual-processor computer. Additional query words: sql6
Keywords : kbprg kbusage SSrvStProc kbbug6.00 kbfix6.00.sp3 |
Last Reviewed: March 24, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |