Sql server 2008 R2

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?

Thanks,
Webboy2008Asked:
Who is Participating?
 
Anthony PerkinsConnect With a Mentor Commented:
Right.  By default it is not there.  You have to change it from Script Data = False to Script Data = True.
0
 
Webboy2008Author Commented:
How about sql server 2005.?
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
Webboy2008Author Commented:
And I tried my sql server 2008. I don't see the option there.
0
 
Anthony PerkinsCommented:
>>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?
0
 
Webboy2008Author Commented:
It is Sql 2008 Server. Not express
0
 
Anthony PerkinsCommented:
Ok.  So what option is not there?
0
 
Webboy2008Author Commented:
Script Data = True is not there.
0
All Courses

From novice to tech pro — start learning today.