I have a few tables I created on a test SQL server 2005. I need to create that table on a production server now. I was able to do that using CREATE TO command that sql generated for me. But I need the data in the table also to be exported and imported into my production version.
Is there a simple way to do this? I was hoping the CREATE TO statement would have had the data in it also, but it didn't