EXEC sp_dropserver ‘ITSV2‘, ‘droplogins‘
exec sp_addlinkedserver ‘ITSV2‘ , ‘‘ , ‘SQLOLEDB‘ , ‘168.9.123.123‘
exec sp_addlinkedsrvlogin ‘ITSV2‘ , ‘false‘ , null , ‘sa‘ , ‘sa‘
drop table test2;
select top 12 * into test2 from ITSV2.InfoDB.dbo.city
select top 2 * from test2