DBCC FREESESSIONCACHE (Transact-SQL)
Applies To: SQL Server 2014, SQL Server 2016 Preview
Flushes the distributed query connection cache used by distributed queries against an instance of Microsoft SQL Server.
Applies to: SQL Server (SQL Server 2008 through current version).
- WITH NO_INFOMSGS
Suppresses all informational messages.
Requires membership in the sysadmin fixed server role.
The following example flushes the distributed query cache.
USE AdventureWorks2012; GO DBCC FREESESSIONCACHE WITH NO_INFOMSGS; GO