0
Posted on 3:54 AM by Softminer and filed under

DeviceName is the name of another sqlinstance

EXEC sp_addlinkedserver @server='sqlinstance', @srvproduct='',@provider='SQLOLEDB',@datasrc='sqlinstance\instance1'


EXEC sp_addlinkedsrvlogin 'sqlinstance', 'false', NULL, 'sa', ''

select * from sqlinstance.Table.dbo.linklist
0
Responses to ... Run query from another computer in SQL Server