Number one of many rants about Management Studio, not #1 as in this is the worst thing about MS, because it's not the worst thing:
Scripting a database to SQL Server 2000 (i.e. 8.0) format using the Tasks | Generate Scripts feature gives me a nice .sql script file. But when I run it in SQL 2000's Query Analyzer, it fails with syntax errors! Specifically, it's missing open parentheses on multiple lines. You've got to be kidding!
I know I can fix all of these errors, and I know there are products that do a better job of scripting database schema than Microsoft's own tools. But, this should work.
If I have time and continue with the many complaints I have about Management Studio, the conclusion is obvious: we need a much better IDE for SQL Server 2005.
