sysdepends

  • Hi,

    I've just found entries in sysdepends that have a depid that does not exist in sysobjects (a phantom id). Does anyone know why?

    eg.

    select *

    from sysdepends

    where depid = 1234

    (returns several rows)

    select *

    from sysobjects

    where id = 1234

    (returns 0 rows)

    Also, there's dependencies that definitely exist that are simply not in sysdepends. Again, any ideas?

    Cheers

  • Sysdepends ends up not being very reliable. Plus, it has no concept of cross db dependencies, so you end up keeping track manually anyway.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

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

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