Mahmood,

The records in Sql Server table are stored in no particular order. The table can only be physicaly ordered by creating clastered index. You can always use ORDER BY clause of SELECT statement to order records in any order you need.

>Hi All:
> I have a table on the server. The sort order is not right on this table.
>For example, the first row in this table has 66323 as the id and second has 66282. The rows are not in asc order. How can I order this table so the ids are in asc order?
>Thanks
>MA