Flush the distributed query connection cache.
Syntax
DBCC FREESESSIONCACHE [WITH NO_INFOMSGS]
Key:
NO_INFOMSGS - Suppress all information messages.
Requires membership in the sysadmin fixed server role.
USE MyDatabase;
GO
DBCC FREESESSIONCACHE WITH NO_INFOMSGS;
GO
“It's hard to be funny when you have to be clean” ~ Mae West
DBCC FREEPROCCACHE - Remove items from plan cache.
DBCC FREESYSTEMCACHE - Release all unused cache entries from all caches.
