I have to give a special mention to this tool as it helps me generate scripts for my Unit Tests really quickly.  It's free at the moment, although each version has an expiration date, but it's well worth a look if you need something to quickly generate scripts.

http://www.sqlscripter.com/

It's also an example of REALLY GOOD USER INTERFACE DESIGN.  The author has taken the time to predict what you're most likely to do and wrapped up any repetitive tasks (for example logging in to the same database with the same credentials, or scripting a certain subset of tables with the same criteria).  You can tell it's a bit rough round the edges, but then it's not a commercial product yet.