Post reply

Restoring lost dependencies

  • June 3, 2011 at 12:45 pm

    #99676

    Is there some way to restore all lost dependency information in SQL 2K?

    i.e.,

    create proc1,

    create proc2 which calls proc1,

    delete proc1

    re-created proc1

    sp_depends returns nothing for both proc1 and proc2

    Thanks!

  • June 6, 2011 at 2:20 am

    #1334231

    Run proc2.

    _____________
    Code for TallyGenerator

  • June 6, 2011 at 5:51 am

    #1334328

    Doesn't do it. On both sprocs, sp_depends returns no results.

    if object_id('proc1') is not null

    drop proc proc1

    go

    create proc proc1

    as

    print 'proc1'

    go

    if object_id('proc2') is not null

    drop proc proc2

    go

    create proc proc2

    as

    exec proc1

    go

    exec sp_depends proc1

    go

    exec sp_depends proc2

    go

    drop proc proc1

    go

    create proc proc1

    as

    print 'proc1'

    go

    exec proc2

    go

    exec sp_depends proc1

    go

    exec sp_depends proc2

    go

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

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