Dependancies

  • I have found a little problem in that due to the way in which software releases happen in my organisation that the order in which stored procs and triggers are inserted or updated is not always correct and the sysdepends table is often incomplete because of this.

    Does anyone know of a way to take an existing database and correct the sysdepends table without having to manually review and reload each proc/trigger in the correct order.

    Thanks

    Terry

  • There isn't a good way to do this. Some of the 3rd party vendors like Red Gate, have figured this out for their Compare tools, but they haven't published a tool or way to do this separately.

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

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