• Madhu R (3/23/2010)


    Hi,

    Thanks for your script.

    I run the script. But its didn't turned out any index need to be defrag or whatever.. !! First its told me the PROC is not available. And I changed as "CREATE" instead of "ALTER".

    Please assist me.

    Did you change these values?

    @minFragPercent = 70,

    @maxFragPercent = 100,

    @minRowCount = 1000