Pages

Monday, June 2, 2014

Oracle Linked Server in Sql Server

EXEC sp_addlinkedserver 'OraCMSRFID', 'CMSRFID', 'MSDAORA', 'CMSRFID'
                                           name                   service name                        servicename

EXEC sp_addlinkedsrvlogin 'OraCMSRFID', false, 'sa', 'oraUID', 'OraPwd'

select * from openquery(OraCMSRFID, 'select * from tabemp')

No comments:

Post a Comment