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.service
ms.component	t-sql|database-console-commands
ms.reviewer
ms.suite	sql
ms.technology	database-engine
ms.tgt_pltfrm
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
caps.latest.revision	15
author	barbkess
ms.author	barbkess
manager	craigg

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)