Cached data from linked server

I've been able to verify that my SQL Server 2000 instance is caching data
from a linked Sybase server. The only way I've been able to flush the cache
is to drop and recreate the link. Does anyone else know how to get SQL
Server to either not cache the data or to periodically flush the cache.
As for the evidence, I have TLU fields that are updated and in Sybase the
latest TLU is from just moments ago, while the TLU when queried from SQL
Server via link is back from 1/24/06.To flush the data, you can setup a job that will issue checkpoint every second.
"John Mark Howell" wrote:
> I've been able to verify that my SQL Server 2000 instance is caching data
> from a linked Sybase server. The only way I've been able to flush the cache
> is to drop and recreate the link. Does anyone else know how to get SQL
> Server to either not cache the data or to periodically flush the cache.
> As for the evidence, I have TLU fields that are updated and in Sybase the
> latest TLU is from just moments ago, while the TLU when queried from SQL
> Server via link is back from 1/24/06.
>
>|||Sorry but that did not work. I opened a Query session to the SQL
Server containing the links and executed CHECKPOINT. But running a
query on one of the linked servers returned the old results. (I double
checked that the data existed by running the same query in DBArtisian).
Was there something else I was supposed to do?
harvinder wrote:
> To flush the data, you can setup a job that will issue checkpoint every second.