Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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