Home Forums Article Discussions Article Discussions by Author Discuss content posted by Oxygen SQL Server 2005: Script all Indexes RE: SQL Server 2005: Script all Indexes

  • February 8, 2013 at 8:07 am

    #1585979

    Jonathan AC Roberts (1/22/2013)

    Jeff,

    The following lines in the SP exclude the primary key and any indexes that are created via adding a unique constraint rather than adding a unique index.

    AND SI.is_primary_key = 0

    AND SI.is_unique_constraint = 0

    Sorry for the late feedback. Yes, I agree. I just can't imagine why anyone would do such a thing in a script titled "Script [font="Arial Black"]ALL [/font]Indexes".

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