In SQL Server 2000, you could generate a SQL script easily using the Generate SQL Script wizard. You could get to it from pretty much anywhere from within Enterprise Manager. For instance, you can get to it by right clicking on any object in the database, then selecting All Tasks, and then selecting Generate SQL Script.
In SQL Server 2005, it is now called Generate Scripts. The only place that I can find where you can get to it is if you right click on the database, then selecting Tasks, and then selecting Generate Scripts. The 2005 wizard does not resemble the 2000 wizard, so you have to use it a few times before you are comfortable with it.
The most annoying thing with the new 2005 scripting wizard is that you can not generate both CREATE and DROP statements together like you could in the 2000 scripting wizard. When you select the Script Behavior field, it indicates that this is possible. However, it is not! Check this out:
Notice in the description that it says you can do either CREATE, DROP, or DROP followed by CREATE. However, when you look at the dropdown options, only DROP or CREATE is available.
I am running SQL Server 2005 service pack 1 already. Let's hope they fix this in the next service pack.