Tips for using SQL Server 2012 Distributed Queries Ensure that user own the table or a member of the sysadmin fixed server role, the db_owner fixed database role, or the db_ddladmin fixed database role on the linked server. To create the best query plans when you are using a table on a linked server that an instance of SQL Server,…