sql server 2008 - database publishing

http://blog.sqlauthority.com/2009/07/29/sql-server-2008-copy-database-with-data-generate-t-sql-for-inserting-data-from-one-table-to-another-table/

SQL SERVER 2005 - Generate Script with Data from Database – Database Publishing Wizard

http://blog.sqlauthority.com/2007/11/16/sql-server-2005-generate-script-with-data-from-database-database-publishing-wizard/

the folder contains sqlsubwiz.exe:
C:\Program Files\Microsoft SQL Server\90\Tools\Publishing\1.2

on the command prompt;
type cd C:\Program Files\Microsoft SQL Server\90\Tools\Publishing
type sqlpubwiz script -d AdventureWorks AdventureWorks.sql