By now you probably know that the first Community Technology Preview (CTP) of SQL Server 2005 Service Pack 2 is available. I wanted to highlight what I see as the most important addition:
"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."
Take it from me, when I found that these two incredibly simple but incredibly useful features had gone missing since SQL Server 2000 I was a little...annoyed... to say the least and I complained vigorously about it. Thankfully the powers that be have had the good sense to replace them.
Its beyond the realms of my understanding why they removed them in the first place.
-Jamie