>>Yes. You cannot expect any order to the data unless you use an ORDER BY clause
>
>Yes, correct, but it is interesting to know that one data provider will differ, in regards to that, from another. I guess SSMS has its own ways of retrieving data which is different than the SQL Client provider used from an ASP.NET application.
Even in SSMS you can not predict the order without ORDER BY clause. If you need specific order, you must use ORDER BY, there is no way around it.
If it's not broken, fix it until it is.
My Blog