Select into from one sql server into another?
Use Sql Server Management Studio's Import feature.
- right click on database in the object explorer and select import
- select your source database
- select your target database
- choose the option to 'specify custom query' and just select your data from T1, in DB1
- choose your destination table in the destination database i.e. T2
- execute the import
create a linked server. then use an openquery sql statement.