We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

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

Medium Priority
1,053 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?
Comment
Watch Question

Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Scott PletcherSenior DBA
CERTIFIED EXPERT
Most Valuable Expert 2018
Distinguished Expert 2019
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Top Expert 2004

Commented:
Agree with brokeMyLegbiking--194 is the RTM version of SQL Server....
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Commented:
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
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.