Home Forums SQL Server 2005 Administering stored procedure is valid or not valid. RE: stored procedure is valid or not valid.

  • December 20, 2007 at 1:16 pm

    #761899

    I don't believe so... other than running it or taking it apart and running the peices...

    You could always setup to exec it and run an estimated execution plan on it, but if it creates temp tables, you may get false errors.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)