script to check stored procedures

• Jonathan Stokes

  SSCrazy Eights

  Points: 9861

  More actions

  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!

• sqlemail@yahoo.com

  SSC Eights!

  Points: 919

  More actions

  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