We have recently upgraded from Server 7 to Server 2000. I am getting table
data sorted in a different sequence to how it was ordered in Server 7. It I
do not specify the 'order by' clause, what determines the sequence of the
data in a table when I view it? I would have expected it to be the order
the data was added to the table but that does not appear to be the case. Do
indexes get used or is it something else?

Regards,
Colin Shelton.
IT Services,
UCE, Perry Barr, Birmingham, B42 2SU.
Tel: 0121 331 5665
Email: colin.[Email Address Removed]MS Sql Server LazyDBA home page