Blair Dee-474691 (4/29/2013)
hey thanks for the tip. I did download and install that and it looks like it will generate the script to copy the data over but it does not create the script to actually create the table structure. any ideas for that?
ok that part is the easiest: Scripting the DDL for any object is already built into SSMS:
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!