Lightweight plugin or procedure for sqlserver Management Studio before row insertion script

Question

I could never find a good script or plugin for SQL Server Management Studio (2005 and 2008) for the very common need for creating scripts: specifying several / all rows in a table and scripts for inserting them. You can guess about my story: I have some configuration data in my dev db and I need a script to deploy to UAT and then to create.

In the past, I found several clumsy systems that had more problems than they cost. I need something free and unobtrusive. As soon as I find this, I will share it with the other 20 developers in my store, whom it annoys. By the way, aren't we all annoyed by this?

What is the best, easiest, free way to specify several / all rows in a table and get a script to insert them?

Edit

Resolution: SSMS Tools Pack Cliffs! Just what I was looking for: free, unobtrusive, simple, durable. It has many other handy add-ons that I look forward to learning.

Answer 1

SMSS Tools can do this. Varieties.

Answer 2

You can use RedGate Data Compare to compare tables (tables) between databases. It will generate inserts for you.

Answer 3

Well, anytime when we add rows to the lookup table in dev, we do this in the script insert, which is placed in the original control like the rest of the project. The script then runs as part of the deployment.