• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 303
  • Last Modified:

what is "Microsoft SQL Server 2000 - 8.00.2189"

i ran select @@version on a client database and came back with :
Microsoft SQL Server  2000 - 8.00.2189 (Intel X86)   Mar 15 2006 07:10:14   Copyright (c) 1988-2003 Microsoft Corporation  Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

-- I looked here for service packs:http://sqlserverbuilds.blogspot.com/
I dont see a SP for 8.00.2189.

What SP is that?
  • 2
  • 2
2 Solutions
Aneesh RetnakaranDatabase AdministratorCommented:
Hello Farzadw,

select serverproperty('productLevel')

Aneesh R
CamilliaAuthor Commented:
for some reason, i thought the @@version result should give the SP. Thanks, that command gave me the service pack.

What's that number....build number?
Aneesh RetnakaranDatabase AdministratorCommented:
yup it is the build version
another source which looks better. the key is that SPs are breakpoints. you must have that SP to install a particular KB

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now