How do you query a linked server?
How do you query a linked server? You must provide a database name in the Data Source DSN. Run Management Studio as Administrator. You must omit the DBName from the query: SELECT * FROM OPENQUERY([LinkedServer], ‘select * from schema.” tablename”‘) How do I give access to a linked server in SQL Server? Expand Server Objects […]