Monday, February 19, 2007 11:02 AM
SQL Server 2005 SP2 Improvements
If you do a lot of scripting, SP2 for SS 2005 is going to be a must-have. Luckily it was just released.
Here are some of the BIG improvements for people who like to script a lot:
- Generate Script Wizard. You can now specify that the scripted objects include a DROP statement before the CREATE statement. Scripting of objects into separate files is now possible. This feature is supported in SQL Server 2005 Express Edition SP2.
- Fewer connection prompts when you open .Transact-SQL scripts. Management Studio determines the connection of the current context. This feature is supported in SQL Server 2005 Express Edition SP2.
[Taken from the What's New document - emphasis added]
Those are some HUGE improvements. I've complained about the multiple scripts problem before - not having it was just unpardonable. And I've wondered, sooo many times, why opening .sql files had to be so painful - glad to see that MS put some cycles in to making that less painful.
There a number of other big improvements too, but these were ones that I was excited about.