Post reply

script to check stored procedures

  • August 5, 2004 at 3:30 am

    #180989

    Has anyone out there a script that i can run after each change in schema that will compile all stored procedures and report back those that have failed due to schema changes.

    as a bonus, it would be great to get back the execution time as well, but I am probably asking a lot.

    ------------------------------
    The Users are always right - when I'm not wrong!

  • August 6, 2004 at 8:27 pm

    #518094

    SP_Depends should list all dependent SP's

    Using TEXT column of SysComments table you can re-create the SP I Guess for these dependent SP's

    I know this will involve some coding, unfortunaltely I dont have the code 🙂


    paul

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

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