How to create and copy tables

[ben2]

Hi I have a basic question. I want to copy a table in a db to another db (in the destination the table has to be created first with proper columns). the table name and schema will remain same. (I'm using sql server 2000). Can you provide sample ado.net code, by which I can achieve that? Thanks

[turbochimp]

Aha - so you did post here as well. See my response in the C# forum, you sly dog. Click here.[^]

The most exciting phrase to hear in science, the one that heralds the most discoveries, is not 'Eureka!' ('I found it!') but 'That's funny...’

[ben2]

This method is fine only when source and destination tables are in the same server. What if they are in different servers?