How to use OPENROWSET instead of a Linked Server in SQL Server

--Use OPENROWSET with SQL Server Authentication
select a.*
from openrowset(
'SQLOLEDB'
,'SERVER=REMOTE_SERVER;DATABASE=dbname;UID=user;PWD=password'
,'select * from [dbname].[dbo].[table]') as a

This site uses Akismet to reduce spam. Learn how your comment data is processed.