I was asked about the "DUMP" command in MySQL yesterday. It will create a script (in order) of all the database objects and the data they contain. The question was, does SQL Server 2005 have anything like that? Why yes it does!
Check out this free tool from Microsoft: http://www.microsoft.com/downloads/details.aspx?FamilyID=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en It's called the "Database Publishing Wizard" and it does just that.
PingBack from http://mstechnews.info/2008/10/sql-serer-2005-script-tables-and-data/