How to get script of SQL Server data?

Question

This question already has answers here:

Answer 1

From the SQL Server Management Studio you can right click on your database and select:

Tasks -> Generate Scripts

Then simply proceed through the wizard. Make sure to set 'Script Data' to TRUE when prompted to choose the script options.

SQL Server 2008 R2

Further reading:

• Robert Burke: SQL Server 2005 - Scripting your Database