Thursday, June 14, 2007

ORDER BY with TOP 100 PERCENT in VIEW bug hotfixed.

Anyone who has been bitten when going from SQL Server 2000 to SQL Server 2005 due to the (intentional) decision by Microsoft to ignore the ORDER BY in a VIEW that returns the entire result set can now get a HotFix to enable the legacy behavior. After installing the HotFix, you will also have to turn on traceflag 168.

No comments: