DBCC FREESESSIONCACHE (Transact-SQL)
Flushes the distributed query connection cache used by distributed queries against an instance of Microsoft SQL Server.
.gif "Topic link icon")
Transact-SQL Syntax Conventions
Syntax
DBCC FREESESSIONCACHE [ WITH NO_INFOMSGS ]
Arguments
- WITH NO_INFOMSGS
Suppresses all informational messages.
Permissions
Requires membership in the sysadmin fixed server role.
Examples
The following example flushes the distributed query cache.
USE AdventureWorks2012;
GO
DBCC FREESESSIONCACHE WITH NO_INFOMSGS;
GO