linked server Caching

Last Post 02 Jun 2002 11:26 PM by vivek_SQL. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
vivek_SQL
New Member
New Member

--
02 Jun 2002 11:26 PM
Consider the senario

I have a database server (A) where i defined a linked server of server (B).
I fire a query from (A) to access (B).Will the results fetched from (B) be cached on (A).
And suppose my server (B) is down due to some network failure.I again fire a query from (A) to access (B).will it give an error or it will pick up records from the cache of the results of (B) on (A).
You are not authorized to post a reply.

Acceptable Use Policy