Microsoft KB Archive/149244

{|
 * width="100%"|

FIX: Repeated Temp Table Creation/Access Can Cause Errs 208/267

 * }

Q149244

-

The information in this article applies to:


 * Microsoft SQL Server version 6.0

-

BUG#: 11400 (6.00)

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

WORKAROUND
Create 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.

STATUS
Microsoft 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 INFORMATION
These 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 : kbprogramming kbusage

Issue type : kbbug

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600