Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [distributed-queries]

6 questions
8
votes
1 answer

Where do Linked Server Queries get executed?

I have two instances ServerA and ServerB, and I have created a linked server in ServerA for ServerB as Linksrv_B. I can execute a query on ServerA using the four part naming convention: SELECT * FROM Linksrv_B.master.sys.databases or…
info.sqldba
  • 327
  • 4
  • 15
2
votes
2 answers

What configurations do I need to fix the "unable to begin a distributed transaction" error when trying to run a remote procedure?

This is the error message I'm receiving: Msg 7391, Level 16, State 2, Procedure spStoredProc, Line 62 [Batch Start Line 1] The operation could not be performed because OLE DB provider "SQLNCLI11" for linked server "MyLinkedServer" was unable to…
J.D.
  • 40,776
  • 12
  • 62
  • 141
2
votes
2 answers

Can the FORCESEEK query hint be used on tables being queried against on a linked server? (I.e. as part of a distributed query)

I have a query that uses the FORCESEEK hint and runs fine on the server where the database I'm querying lives. If I try to run the same exact query remotely from a different server (targeting the original server), I get the following error: Msg…
J.D.
  • 40,776
  • 12
  • 62
  • 141
2
votes
1 answer

how to temporarily change the sql server settings in order to do a task and when finished revert back?

when I run the script below all at once I get this error message: Msg 15281, Level 16, State 1, Line 58 SQL Server blocked access to STATEMENT 'OpenRowset/OpenDatasource' of component 'Ad Hoc Distributed Queries' because this component is…
Marcello Miorelli
  • 17,274
  • 53
  • 180
  • 320
1
vote
0 answers

What's an example of a Distributed Database Query?

Since I may not come across or get a chance to use a distributed database system. I would like to understand an example of a Distributed Database Query. I know that in a distributed system, you have database stored on multiple computers connected…
Pierte
  • 11
  • 1
0
votes
0 answers

SQL Server linked server query issue

I am using SQL Server 2016 and recently one of the stored procedures I have been using is throwing error. I use a select statement with joins on many tables to the remote server using a linked server SQL BEGIN TRANSACTION SELECT a.col1, …
ITHelpGuy
  • 109
  • 1