In SQL Server 2008 R2 script data missing on Script Wizard

sql-server sql-server-2008-r2
shamim picture shamim · Dec 6, 2010 · Viewed 25.8k times · Source

In my SQL Server 2008 R2

Script Option Screen of Script Wizard under section Table/View Options Look I find Script Data row and want to turn the option to True but I fail.

I don't find any script data option. Why script data option missing on my SQL Server 2008 R2? Is there any command to generate the insert data option.

Why this problem arise? how to solve it? Thanks in advance

Answer

shamim picture shamim · Dec 6, 2010

It looks like they removed it from that location. You can still do it by:

  • Right clicking on the DB
  • Click on tasks
  • Click on generate scripts
  • Go through the wizard and select your tables
  • On the options page click the Advanced button
  • Change the "Types of data to script" option, from the default "Schema only" to "Schema and data".

Related questions

Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)

I have a development database that re-deploy frequently from a Visual Studio Database project (via a TFS Auto Build). Sometimes when I run my build I get this error: ALTER DATABASE failed because a lock could not be placed on …

Read More
Select SQL Server database size

how can i query my sql server to only get the size of database? I used this : use "MY_DB" exec sp_spaceused I got this : database_name database_size unallocated space My_DB 17899.13 MB 5309.39 MB It returns me several …

Read More
CREATE TABLE IF NOT EXISTS equivalent in SQL Server

CREATE TABLE IF NOT EXISTS works on mysql but fails with SQL Server 2008 R2. What is the equivalent syntax?

Read More