Hi

I working on ASP.NET
I have 2 databases called databaseA,databaseB.
databaseA reside on ServerA and databaseB reside on ServerB i want to copy the some table from databaseA to databaseB how to do

can it done by select statement or SP?

Normally you can do this directly thru a SQL call. You'd need to write an application that pulls the data from one datasource, and pushes it to another. However, you can link MS SQL Server instances and can then select across server boundaries thru SQL. Post this question in a SQL forum for some help with it. I've never worked with linked servers, I just know that it is possible.

Does the table already exist in both databases (meaning, are you just trying to copy the data) or are you trying to copy both the data AND table schema?

If the table exists in both database and you are just trying to copy the data, you can accomplish this easily by creating one connection to databaseA, and a second connection to DatabaseB. Then create a dataset to each table and use the Merge method of the dataset object to "copy" the data. It works quite well.

Now, if you need to copy the table schema AND data, this gets a little tricky. Ket me know if this is what you are attempting and I will find something to do this (I remember seeing something like this somewhere...just need to find it again).

Scott