Exporting Data

[Just Greeky Creek]

Is there any easy way to Export data between tables with one SQL command without using DTS? I found ExportData , i used but it doesnt work? how will i use it? DB1.dbo.TheSameTable.ExportData (DB2.dbo.TheSameTable) Thanks a lot I remember an Easy Way, Select Into Command :laugh: then alter table for key fields