I ran the script given by James Travis to fix the column

order . It did fix the column order, but the data in the

table got messed up as the colid and colorder columns are updated in

the syscolumns table.

Can anybody explain the reason why the data gets messed up

as the colid and colorder are updated.

Any help is appreciated and can email to sridhar_t @hotmail.com

Thanks

Sridhar