copy table from 1 db to another

[rds747]

How do I copy one table from one database to another?

 

[jbenson001]

What do you want to copy, just the structure, or the data, indexex, constraints..etc??

Jim

 

[rds747]

Just the data

 

[jbenson001]

So you have the table on the second DB with the same structure?
Then you can use DTS by creating a package or using the Import/Export wizard. More simply use an Insert Into statment:

Insert Into DBName.OwnerName.TableB(column list here)
   Select Column List Here from TableA

If the table doesn't yet exist on the second DB:

Select * 
Into DBName.OwnerName.TableB
From TableA

Jim