DBCC FREESESSIONCACHE (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Flushes the distributed query connection cache used by distributed queries against an instance of 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)