Solved

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

Posted on 2004-03-30
7
959 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
ID: 10717073
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:Scott Pletcher
Scott Pletcher earned 41 total points
ID: 10717077
Try:

SELECT SERVERPROPERTY ('ProductLevel')

0
 
LVL 34

Expert Comment

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

Assisted Solution

by:jaryco
jaryco earned 41 total points
ID: 10717509
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
ID: 11035332
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

808 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