Post reply

View system stored procedures...

  • December 9, 2007 at 10:41 pm

    #154008

    Experienced in SQL Server 2k and just installed 2k5... in 2k, it was fairly easy to view the code in system stored procedures... how is it done in 2k5? I've tried right clicking on the procs, but no joy...

    Thanks, folks.

    --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 9, 2007 at 11:12 pm

    #758469

    In SSMS you right click on the system stored proc and choose modify. that's it.

  • December 9, 2007 at 11:48 pm

    #758474

    Thanks... I'll give 'er a whirl. Funny how they've so radically changed the terminology...

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

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

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