Difference between Reconnect and Reflesh buttons | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Difference between Reconnect and Reflesh buttons

Hello people, In Analysis Services 2005’s cube browser, there are two buttons "Refconnect" and "Refresh", which is the difference between them?? When should I use each one? Thanks in advance. Hernán.

http://download.microsoft.com/download/8/5/e/85eea4fa-b3bb-4426-97d0-7f7151b2011c/SSAS2005PerfGuide.doc fyi. BOL
For client applications connected to an instance of Microsoft SQL Server 2005 Analysis Services (SSAS), this statement causes the memory cached on the client application to be synchronized with the server. While this will ordinarily be detected and updated automatically, the length of time before this happens depends on the client connection string settings. The REFRESH CUBE statement refreshes data immediately. For client applications connected to a local cube, the REFRESH CUBE statement causes the local cube file to be rebuilt.
Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

]]>