Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2005-02-07 : 03:28:44
|
| How to find the service pack version in sql server analysis services?------------------------I think, therefore I am |
|
|
nbpatil
Starting Member
14 Posts |
Posted - 2005-02-10 : 19:42:14
|
| Ravi,Check your SQL versions.2000.8.0.760 Analysis Services SP 3 2000.8.0.532 Analysis Services SP 2 2000.8.0.382 Analysis Services SP1 ~ Nitin Patil (System Analyst) OSI Systems,Inc. CA,USA |
 |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2005-02-11 : 01:09:23
|
| I think the above list is for the SPs of SQL SERVER not analysis services. Are sure about that?------------------------I think, therefore I am |
|
|
|
nbpatil
Starting Member
14 Posts |
Posted - 2005-02-11 : 01:21:44
|
| Yes ,i am sure abt this. Check out this ......-----------------------------------------------To determine the version of Analysis Services, locate the msmdsrv.exe file in the Microsoft Analysis Services\Bin folder and then right-click this file to get the version information from the Properties dialog box. If the file version is 8.00.760, you have applied SP3. DSO: To determine the version of DSO, locate the msmddo80.dll file in the Program Files\Common Files\Microsoft Shared\DSO folder and then right-click this file to get the version information from the Properties dialog box. If the file version is 8.00.0760, you have applied SP3. While the version of the msmdsrv.exe and msmddo80.dll files will be identical after a service pack installation, the installation of hot fixes can result in different values for these two crucial files. Analysis Manager: To determine the version of Analysis Manager on a client computer, right-click the Analysis Servers object in Analysis Manager and then click About Analysis Services. If the version is 8.0.760, you have applied SP3. If you click About Microsoft SQL Server Analysis Services on the Help menu in Analysis Manager, the build number returned is the build number of the Analysis Manager Microsoft Management Console (MMC) snap-in. PivotTable Service: To determine the version of PivotTable Service, locate the msolap80.dll file in the Program Files\Common Files\System\Ole DB folder and then right-click this file to get the version information from the Properties dialog box. For example, if the file version is 8.00.760, you have applied SP3. (msolap80.dll) --------------------------------------------------------------------------------------Hope this will help you out.~ Nitin Patil (System Analyst) OSI Systems,Inc. CA,USA |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2005-02-11 : 01:33:30
|
| Thank you. I was looking for this for a long time.------------------------I think, therefore I am |
|
|
|
|
|
|
|
|
analysis services SP