So, I was poking around SQL Server 2008 Management Studio the other day to generate some scripts.
My eyes almost bulged out of my head.
Here's a screen-cap of the 'Choose Script Options' page that caught my attention. The same screen from SSMS 2005 is in the background, with the new option in SSMS 2008 in the foreground:
Best of all, works EXACTLY as you would suspect.
Finally, SQL Server gives us the ability to effectively 'dump' a database.
Expect some new videos (on this and other topics) in a week or so.