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

What worked for me was to turn on Profiler and use "Error and Warnings" events. Then select all the expanded columns to get as much data as I could....

I just loaded a database that a client had created 5 indexes for 5 columns and it was always my belief that SQL was smart enought to use a single...