Microsoft KB Archive/112712

{|
 * width="100%"|

BUG: Stored Procedure Tree May Grow After Restarting Server

 * }

Q112712

-

The information in this article applies to:


 * Microsoft SQL Server version 4.2x

-

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