>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.