BUG: Stored Procedure Tree May Grow After Restarting Server

ID: Q112712

The information in this article applies to:

BUG# OS/2: 1557 (4.2)
       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.

Additional query words: 703 


Keywords          : kbprg SSrvStProc kbbug4.20 SSrvWinNT 
Version           : 4.2 | 4.21
Platform          : OS/2 WINDOWS 
Issue type        :

Last Reviewed: March 18, 1999