SQL Server 2008 has a new feature where you can script out data in tables via INSERT statements. Just do the following:
1. Right click on the database and select “Generate Scripts…”
2. Select the database.
3. This is the hidden part. Set “Script Data” to true.
4. Select Tables.
5. Select Tables.
6. You can script out a table script per file or as a single file. I prefer ANSI text.
7. Hit Finish.