• Code fix

    It's already been commented on once, but the code has not been modified

    --ORDER BY SYSCOLUMNS.COLID - This is the original code -- it will create the composite indexes with the order of columns WRONG Tested on SQL 2000 SQL 2008

    ORDER BY SYSINDEXKEYS.keyno - It should be

    Still a great script, saved me time, another example of test - test - test before you run a downloaded script.