That doesn't give us much to go on without knowing the
error, if you are using linked servers, openquery, or how
you are running whatever directly on the first server. The
best you can do is review the topics in books online related
to Linked Servers as well as Distributed Queries.
-Sue
On Fri, 21 Apr 2006 10:55:02 -0700, Steve Lowrance
<SteveLowrance@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
How can I use Query on a client connected to one server when the query pulls
data from the connected server and from another server. Now we get an error
when the query attempts to read from the other server.
If we run the query directly on the first server, it pulls from the other
server with no problems.
Re: Job Failure ... Tibor Karaszi, SQL Server MVP... > set up to use a valid account on the linked servers.... >>You will get problems is the job owner isn't sysadmin,... (microsoft.public.sqlserver.server)
RE: Memory issues with Linked Servers ... That worked for the reading part of the linked server... we are able to fix the linked servers.... > gets memory for its OLE DB providers) to see if it is indeed getting ... > MemToLeave space being exhausted? ... (microsoft.public.sqlserver.server)
Re: Wierd Primary Key issue ... the production server and then I removed the foreign key restraints. ... I have written queries to access data on linked servers using 4-part names ... The columnthat make up the primary key:... (microsoft.public.sqlserver.tools)
Re: SQL2005 Linked server authentication problem ... out this double-hop kerberos issue with linked servers in SQL2005 is an ... The problem occurs when I tried to connect from a client PC, to a SQL... from a different server e.g. ... (microsoft.public.sqlserver.security)
Re: Wierd Primary Key issue ... You probably ended up with duplicates because the select ... Try removing the NOLOCK.... >the production server and then I removed the foreign key restraints. ... >> I don't use openquery with linked servers.... (microsoft.public.sqlserver.tools)
