Select into from one sql server into another?

sql sql-server sql-server-2008

create a linked server. then use an openquery sql statement.

sql sql-server sql-server-2008

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

sql sql-server sql-server-2008

select * into [newtable] from [linked_server].[databasename].dbo.[tablename]

CodeHunter