Opening a table in SSMS by using the Open Table feature is the equivalent of performing a SELECT statement without an ORDER BY clause. Without an ORDER BY clause, the order in which rows are returned is not guaranteed or predictable. The presence of indexes on the table does not affect this.
Kind regards, Gail
Gail Erickson [MS] This posting is provided "AS IS" with no warranties, and confers no rights