Post reply

Update dependencies

  • July 25, 2005 at 11:41 am

    #167603

    Sometimes when a stored procedure or UDF is created some of the objects called inside don't exist yet. As a result, the procedure is created but a message like the one below is displayed:

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

    Is there any command or something that can verify and update dependencies for existing objects? I know that everything will be updated when the SP or UDF runs for the first time, as all the object must exist in order for it to run, but I would like to know if I can to it manually

     

    Thanks

  • July 25, 2005 at 12:19 pm

    #576898

    There are no documented ways of doing so, short of modifying sysdepends itself. However, with that said, SQL Server doesn't rely on sysdepends for the processing of queries. Do you have a reporting process or something of that sort that queries against sysdepends?

    K. Brian Kelley
    @kbriankelley

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply