DBCC FREESESSIONCACHE (Transact-SQL)
Flushes the distributed query connection cache used by distributed queries against an instance of Microsoft SQL Server.
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 AdventureWorks2012; GO DBCC FREESESSIONCACHE WITH NO_INFOMSGS; GO