REPEATABLE READ

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.