Welcome to SSQA.net Sign in | Join | Help

Business Continuity (SSQA.net)

Business continuity & Contingency planning - essential and unavoidable tasks.
How to find which version of Analysis Services you are running?

Using SELECT @@VERSION statement you can get simply get information of SQL Server you are running , when connected to that SQL Server instance. What if to know same for the Analysis Services components, we don't have such an easy way to find out!

I mean there isn't a straight way to find out, but using few statements you could get it, by using following fashion:

Analysis Services 

From the Start menu, point to Program Files, point to SQL Server 2000, point to Analysis Services, and then click Analysis Manager. 
 

  • In the Analysis Manager tree, right-click the Analysis Servers node, and then click About Analysis Services. 
     
  • Use the following table to determine which version of Analysis Services you have. 
     
     
    Also you can use MSMDSRV.EXE file by looking at properties of this file from Windows Explorer.

Further you can refer to the SSAS_OperationsGuide for more information.

 

Posted: Monday, November 05, 2007 10:54 PM by SQL Master

Comments

Other SQL Server Blogs around the Web said:

Using SELECT @@VERSION statement you can get simply get information of SQL Server you are running , when

# November 5, 2007 11:29 PM

SSQA.net - SqlServer-QA.net said:

Using SELECT @@VERSION statement you can get simply get information of SQL Server you are running , when

# November 6, 2007 12:01 AM
Anonymous comments are disabled