Bemærk
Adgang til denne side kræver godkendelse. Du kan prøve at logge på eller ændre mapper.
Adgang til denne side kræver godkendelse. Du kan prøve at ændre mapper.
Flushes the distributed query connection cache used by distributed queries against an instance of Microsoft SQL Server.
.gif "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