How to script sql server 2005 database with data?

Question

I use sql server 2005 as my database for my web application.... I generated scripts of the database by,

Database->Right Click->Tasks->Generate Scripts

I can script all my Tables,Stored Procedures,User Defined functions,Views,Users......

I have no data in it... I want the data to be scripted.. Any suggestion...

Solution

Another option is to look into SQL Toolbelt. Their SQL Data Compare can script data. This of course hinges on the fact that you're ok spending money to get this done. http://www.red-gate.com/index.htm We use the entire SQL toolbelt where I work - some very useful tools in there.

If you do not wish to go this route - and your data in the pre-scripted database would not change then instead of scripting all the schema you could script the database creation and the restore of a backed up DB.