To handle this scenario, I found an excellent post from Narayana Vyas Kondreddi. All you need to do is install his stored procedure in your master database and then you can generate insert statements by calling that stored procedure in the database or your choosing.
Here are the two main type of execute statements that I found useful.
- Generating inserts for a table where you want all columns scripted:
- Generating a table to include all columns except for the identity column:
Thanks Narayana for a great post!!!