PRB: You Receive a Warning Message When You Create a Recursive Stored Procedure (811483)


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)
  • Microsoft SQL Server 7.0

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 'object name'. 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.
Modification Type:MajorLast Reviewed:10/16/2003
Keywords:kbSQLProg kberrmsg kbprb KB811483 kbAudDeveloper
©2003 Microsoft Corporation. All rights reserved.