Just found out how to generate insert statements in SQL Server Management Studio 2008. I had done it before, but this will be as a reminder.
- Right click on the database and go to Tasks -> Generate Scripts
- Select the tables (or object) that you want to generate the script against.
- Go to Set scripting options and click on 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.
