SQL Packager
Wow. (warning, this may sound like a paid advertisement, but it isn't)
I quickly needed to send a project that included a database with some test data in it. That's normally a pain to do, but I remembered hearing about red-gate's SQL Packager product.
The amazing part is not that it does exactly what I needed, but how it does it. This is one of those wow tools that appears so simple to use. Plug it in and go.
I selected my database, it prompted me for which tables/sprocs to script. It prompted for which tables I wanted to script the data for. Done. In less than 30 seconds from entering the license key I had my script.
It then went on to ask me if I wanted it all packaged up in an executable to send to the client. That's impressive, so I had to say yes just to see how that worked - I got a 300kb exe that when ran asked me for the db details and authentication.
These guys already had me as a customer for life with SQL Compare, but I highly recommend checking out red-gate for any SQL-related tools.