BUG: Stored Procedure Tree May Grow After Restarting Server

• Microsoft SQL Server version 4.2 for OS/2
• Microsoft SQL Server, version 4.21

       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 SQL Server version 4.2 for OS/2 and Microsoft SQL Server version 4.21. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.