dbcc-freesessioncache-transact-sql.md

title	DBCC FREESESSIONCACHE (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	07/16/2017
ms.prod	sql
ms.prod_service	sql-database
ms.reviewer
ms.technology	t-sql
ms.topic	language-reference
f1_keywords	FREESESSIONCACHE FREESESSIONCACHE_TSQL DBCC_FREESESSIONCACHE_TSQL DBCC FREESESSIONCACHE
dev_langs	TSQL
helpviewer_keywords	DBCC FREESESSIONCACHE statement distributed queries [SQL Server], cache clearing distributed query cache flushing distributed query cache
ms.assetid	a256ba63-7e11-4d5e-abc0-1fa4ed072e63
author	pmasl
ms.author	umajay

DBCC FREESESSIONCACHE (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

Flushes the distributed query connection cache used by distributed queries against an instance of [!INCLUDEmsCoName] [!INCLUDEssNoVersion].

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)