I'm new to SQL Server, just viewing my tables with Enterprise Manager. There
doesn't seem to be a way to sort on a field. I'm used to access where you
just rigth clicked on the field name at the top of the table and you could
then sort ascending and descending on that field. The data in sql doesn't
seem to be in any order at all, not the order it was created in, not the
order of the key field - those wacky folks at Microsoft! How do I view my
data sorted???? Thanks!

[quoted text, click to view]

Welcome to SQL. That means grap a book and learn ANSI SQL. Walk away
from the gui and launch the Query analyzer. The only time I ever use
the EM to look at tables is when the tables are small enough to view
AND I want to edit a row. I mean real small tables (like a types table
vs order_detail). Too much to get into here, but the order of the
physical data is unimportant for most queries - if you need to sort on
a column, add "order by [column] asc/desc". Just as easy to do that
than to click on a column. It gets easier man. And much more powerful