I always find it frustrating in SQL2005 (I know things are different in 2008) that Enterprise Manager doesn't provide an option to export data in your tables out as SQL Scripts. I can send to CSV, DTS, Text etc. but not a SQL Script. I came across a free tool that solves my problem: SQL Scripter – http://www.sqlscripter.com/. It also has a few options like insert new, insert all, update new etc. which would be really handy if you want to sync between 2 databases using scripts only.
