Sql server 2008 R2

Posted on 2011-02-18
Last Modified: 2012-08-13
I have some tables that have data there. My plan is to have one .sql to do the following:

1. The script will have create table code and all of the data in the table will be in the script as well.

for example. I have table customer and have column first name, last name with data John Smith.
I want to get script from sql server 2008. Included the table structure and the data into one script. Does it seem possible?

Question by:Webboy2008
  • 4
  • 3
LVL 12

Expert Comment

ID: 34930972

Author Comment

ID: 34931163
How about sql server 2005.?

Author Comment

ID: 34931332
And I tried my sql server 2008. I don't see the option there.
LVL 75

Expert Comment

by:Anthony Perkins
ID: 34931362
>>How about sql server 2005.? <<
"Script Data option is new with Microsoft SQL Server 2008"

>>And I tried my sql server 2008. I don't see the option there.<<
Are you using the Express Edition?
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline


Author Comment

ID: 34931403
It is Sql 2008 Server. Not express
LVL 75

Expert Comment

by:Anthony Perkins
ID: 34934068
Ok.  So what option is not there?

Author Comment

ID: 34964507
Script Data = True is not there.
LVL 75

Accepted Solution

Anthony Perkins earned 500 total points
ID: 34966972
Right.  By default it is not there.  You have to change it from Script Data = False to Script Data = True.

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now