Get all the records of the table from the SQL Server Database

Hi, all I got one stupid question in mind. The idea is that I want my SQL database to install into another computer. The best way for me is I want to create a script file for creating tables, triggers, stored procedure. But I want all the SQL statement that insert all the records in to each table too.

Does anyone have a solution for me? Or there be other way?
I am always waiting for ur suggestion.You can take the backup of the database and then restore. This will restore everything (Table structure / SP's etc along with data.

Check the article for backup/restore:

http://vyaskn.tripod.com/backup_and_restore_with_sql_litespeed.htm|||Thank a lot.