Post reply

stored procedure is valid or not valid.

  • December 20, 2007 at 12:57 pm

    #182155

    Hi All

    One question :Is there any method to find out stored procedure is valid or not valid.

    Please help me

    Regards,

    Shine

  • 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)

  • December 20, 2007 at 1:23 pm

    #761902

    It also really depends on what you mean by valid? You could look at the dependencies to make sure they all exist for that SP.

    select object_name(so.id), object_name(depid)

    from sysdepends sd

    inner join sysobjects so

    on so.id = sd.id

    where so.xtype = 'P'

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

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

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