Flushes the distributed query connection cache used by distributed queries against an instance of Microsoft SQL Server.
Transact-SQL Syntax Conventions
DBCC FREESESSIONCACHE [ WITH NO_INFOMSGS ]
Suppresses all informational messages.
Requires membership in the sysadmin fixed server role.
The following example flushes the distributed query cache.
USE AdventureWorks; GO DBCC FREESESSIONCACHE WITH NO_INFOMSGS; GO