SQL Server: Generating the Schema and Data with SqlServer 2008 R2 Management Studio

1. Right click on the database.
2. Select Tasks -> Generate Scripts.
3. Select the "Script entire database and all database objects" radiobutton.
4. Click Next.
5. In the "Scripting Options" screen, click the "Advanced" button.
6. In the "General" category change the "Types of data to script" value to "Schema and Data".
7. Click OK.
8. Click Next.

Now, you will get the schema scripts as well as the tabulated data of the database.