DBCC FREESESSIONCACHE (Transact-SQL)

**APPLIES TO:** ![yes](media/yes.png)SQL Server (starting with 2008) ![no](media/no.png)Azure SQL Database ![no](media/no.png)Azure SQL Data Warehouse ![no](media/no.png)Parallel Data Warehouse

Flushes the distributed query connection cache used by distributed queries against an instance of Microsoft Microsoft SQL Server

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  

See Also

DBCC (Transact-SQL)