MS-SQL Linked server( DB-LINK) 설정

다음번 검색질을 줄이기 위해...

 

 

 

 

 

sp_addlinkedserver
'DB2',
'MSSQL',
'SQLOLEDB',
'127.0.0.1',
NULL


sp_addlinkedsrvlogin
'DB2',
'false',
NULL,
'sa',
's9ak2!'


sp_testlinkedserver
DB2

 

select * from DB1.TESTDB.dbo.VW_PA01

select * from DB2.TESTDB.dbo.VW_PA01

 

Trackbacks 1 / Comments 0

Leave Comments