Microsoft KB Archive/811483

= PRB: You Receive a Warning Message When You Create a Recursive Stored Procedure =

Article ID: 811483

Article Last Modified on 10/16/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition
 * Microsoft SQL Server 7.0 Standard Edition

-



SYMPTOMS
When you create a recursive stored procedure, you receive the following warning message:

Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object ' '. The stored procedure will still be created.

Note The object name refers to the name of the stored procedure that you create.



CAUSE
When you create a stored procedure, the name of the stored procedure is stored in the sysobjects table, and information about the stored procedure dependencies is added to the sysdepends table. You receive the warning message when the stored procedure refers a stored procedure object that does not exist in the database. With a recursive stored procedure, the stored procedure references itself. Therefore, the warning message is displayed while you create the recursive stored procedure.



STATUS
This behavior is by design.



MORE INFORMATION
You can safely ignore the warning message because it does not affect the function of the recursive stored procedure.

Keywords: kberrmsg kbsqlprog kbprb KB811483

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.