ORDER BY has never been technically 'allowed' in a view definition. For example, the following code:CREATE VIEW dbo.[UsersByFirstName] AS SELECT * FROM dbo.[users] ORDER BY [FirstName] GO will throw an error if you attempt to run it. Books Online for SQL Server 2000 says: The ORDER BY clause is invalid in views, inline ...

One thing I forgot to cover in my previous 'cheet sheet' post of MSDE functionality was any mention of the price. I bring that up because it bit me in the hiney today. On aspadvice I said that MSDE wasn't free, only free-distributable by owners of certain products (like Visual Studio, etc.) BOY was I wrong. Only, no I wasn't. Which just ...

I'm about to do a couple of posts comparing MSDE against SQL Server Express (or, as I like to call it, SQLE). In these posts I'll cover the facts about MSDE -- in an easy to digest form (I have such a hard time keeping the details straight myself -- I'm sure that others do as well -- so having a simple list of what MSDE does and doesn't do ...