Generate scripts to export table data.

In SQL Server 2008, you can export the data in the table as SQL scripts and execute it on other DBs for importing it. This can be done from the right click menu option "Tasks" + "Generate Scripts" and setting "Script Data" attribute to true. The wizard allows selection of tables to export data from and generates a script that both creates the table as well as inserts the data into the newly created table.

This will be extremely useful to me, as our team is spread across geographic locations tweaking the db everyday!

Thanks for the short post from Mitch.