Usage of DBCC FREESESSIONCACHE

When we write distributed queries,it will use a connection cache against a SQL Server Instance.We can clear that distributed query connection cache using DBCC FREESESSIONCACHE. The only argument "WITH NO_INFOMSGS" will suppresses all informational messages. We should have sysadmin role to issue this command.
Ebook Download
View all
SQL Jobs
Read by 0 people
Download Now!
Learn
View all