Exporting Data from SQL Server Managment Studio as INSERT statements

Another quirk of Microsoft SQL Server Management Studio 2008 - they made the option to export table data as SQL insert statements almost impossible to find. Here's how you do it:

• Right click on the database and go to Tasks -> Generate Scripts
• Select the tables that you want to generate the script for
• Go to Set scripting options and click the Advanced button
• In the General category, go to type of data to script
• There are 3 options: Schema Only, Data Only, and Schema and Data. Select the appropriate option and click on OK

Found that gem here.