BUG: Stored Procedure Tree May Grow After Restarting Server

• 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 listed at the beginning of this article.

Additional query words: 703

Keywords : kbprg SSrvStProc kbbug4.20 SSrvWinNT
Version : winnt:4.2x
Platform : winnt
Issue type : kbbug