Solved

How Do I Find out what Service pack Level I have in MS SQL Server Analysis Services???

Posted on 2004-03-30
7
956 Views
Last Modified: 2012-05-04
I have SQL Server Enterprise Addition with newly installed Analysis Services, we are trying to install MS Project Server to test an Enterprise Project Configuration company wide.  I see that I have  version 8.00.194 by running in the query analyzer SELECT @@VERSION.  

Does that Service Pack 3?
0
Comment
Question by:josephfluckiger
7 Comments
 
LVL 4

Accepted Solution

by:
brokeMyLegBiking earned 43 total points
Comment Utility
8.00.382 is the version of Analysis services that includes service pack 3a, sounds like you need to upgrade buddy.

cheers!
0
 
LVL 69

Assisted Solution

by:ScottPletcher
ScottPletcher earned 41 total points
Comment Utility
Try:

SELECT SERVERPROPERTY ('ProductLevel')

0
 
LVL 34

Expert Comment

by:arbert
Comment Utility
Agree with brokeMyLegbiking--194 is the RTM version of SQL Server....
0
 
LVL 7

Assisted Solution

by:jaryco
jaryco earned 41 total points
Comment Utility
josephfluckiger,

Check the following links to get more information and download the last SQLServer updates.

HOW TO: Identify Your SQL Server Service Pack Version and Edition
http://support.microsoft.com/default.aspx?scid=kb;en-us;321185

SQLServer Service Pack 3a:
http://www.microsoft.com/sql/downloads/2000/sp3.asp

Security Patch MS03-031 (SQL2000-KB815495-8.00.0818-ENU.exe)
http://www.microsoft.com/downloads/details.aspx?FamilyID=9814ae9d-bd44-40c5-add3-b8c99618e68d&DisplayLang=en
0
 

Expert Comment

by:Opiner
Comment Utility
I agree with jaryco, I think the first link explains it very well.

Release                                                    Sqlservr.exe  
RTM (Release To Manufacturing)              2000.80.194.0
SQL Server 2000 SP1                                2000.80.384.0  
SQL Server 2000 SP2                                2000.80.534.0  
SQL Server 2000 SP3                                2000.80.760.0  
SQL Server 2000 SP3a                              2000.80.760.0
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now