Egregious Simple Analysis
I'm working in 2005 Server Management Studio, and am surprised about two things I can't do:
1) When I open a table, I cannot select a column and request a forward or backward sortation (which is something that MS Access lets me do). So I've been making an access database, then ODBC linking to the SQL table and doing inspections of data from within Access.
2) If I have a table open, and make a modification (insert, update, delete), I can't do a "refresh" to the open table to make it reflect the new results. Or, at the very least, I have not found a refresh button somewhere. I'm forced to close the table, and reopen it.
Am I missing something? Is there a simpler way to accomplish the tasks I've outlined above?
(EDIT: I have subsequently noticed the "show diagram," "show criteria," and "show sql" buttons that give me opportunity to take a simple table dump, and manipulate it - like specifying what columns to sort on - and an opportunity re-execute - but this still strikes me as more "busy" than what Access offers)
