Colin,

I remember in SQL class that Collation option wend you first create the
database in SQL2k does affect the sort order.
look at your Documentation Books Online.

Here is some info I found in BOL.
"SQL collations control:

The code page used for storing non-Unicode data in Microsoft® SQL
Server(tm).


The rules governing how SQL Server sorts and compares characters stored in
both Unicode and non-Unicode data types.
Choose a SQL collation if: "

I hope this helps.

Jorge Herrera
Chevy Chase Bank
USA


-----Original Message-----
From: Colin Shelton [mailto:Colin.[Email Address Removed] Friday, June 14, 2002 6:01 AM
To: Mssqldba (E-mail)
Subject: Sorting sequence for table data


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] unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] mail is to be used for Bank business purposes only. Confidential
information should not be sent via email as there is no expectation of
privacy or integrity of the message through the internet.


**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This email message has been scanned for the presence of
computer viruses.

Chevy Chase Bank
**********************************************************************
MS Sql Server LazyDBA home page