Checking the right version & service pack

Question

Post reply

Checking the right version & service pack

raghu_nandan1

SSC Eights!

Points: 966
More actions
July 15, 2003 at 6:17 am

#64789

Hello,
I just joined a company and wanted to know the version and service pack of SQL server..so
I did SELECT @@version
and got the following results:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 3)
Does it mean I am on Service Pack 3?
The reason why I am asking is that our consultant believes we are not on Service Pack 3 based on the number it generated:
8.00.760
Please clarify and also Service pack 3 contains 3 components should I install all 3 of them on the server?
Thanks
Raghu

Raghu

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Kay_dba SSC-Addicted Points: 498 More actions · Answer 1

You are on SP3.

SQL Server 2000 RTM 8.00.194 RTM

Database Components SP1 8.00.384 SP1

Database Components SP2 8.00.534 SP2

Database Components SP3 8.00.760 SP3

As far as what components to install it depends on what to you use.

raghu_nandan1 SSC Eights! Points: 966 More actions · Answer 2

Thanks Kay_dba this helps...

where do I get this information from?

I looked in microsoft web site but I could not find the relevant numbers for service packs.

I will keep looking but just in case you had a quick link to send me to...

Thanks again

Raghu

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 3

The 8.00.XXX info is usually found in the readme file that comes with each service pack. Alternately, Chip Andrews usually keeps the version numbers on his site, http://www.sqlsecurity.com/

HTH.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

K. Brian Kelley
@kbriankelley