BUG: Stored Procedure Tree May Grow After Restarting Server

Q112712

The information in this article applies to:

BUG#  NT:  521 (4.21)

SYMPTOMS

Under some very special situations, a stored procedure tree in sysprocedures may grow in size if the stored procedure creates many temporary tables and vigorously manipulates them using INSERT, DELETE, or UPDATE statements.

The growth may occur each time SQL Server is restarted and the stored procedure is executed for the first time after the restart. The subsequent executions of the procedure do not make it grow if the server is not restarted.


CAUSE

SQL Server may incorrectly maintain stored procedure trees under certain situations if the stored procedure creates and manipulates many temporary tables and SQL Server is restarted.


WORKAROUND

Drop and recreate the stored procedure fixes this problem.


STATUS

Microsoft has confirmed this to be a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: 703

Keywords : kbprogramming
Issue type : kbbug
Technology : kbSQLServSearch kbAudDeveloper kbSQLServ420OS2


Last Reviewed: October 26, 2000
© 2001 Microsoft Corporation. All rights reserved. Terms of Use.