what is "Microsoft SQL Server  2000 - 8.00.2189"

Posted on 2007-11-15
Last Modified: 2008-02-01
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:
I dont see a SP for 8.00.2189.

What SP is that?
Question by:Camillia
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
LVL 75

Accepted Solution

Aneesh Retnakaran earned 250 total points
ID: 20295253
Hello Farzadw,

select serverproperty('productLevel')

Aneesh R

Author Comment

ID: 20295275
for some reason, i thought the @@version result should give the SP. Thanks, that command gave me the service pack.

What's that number?
LVL 25

Assisted Solution

imitchie earned 250 total points
ID: 20295301
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 20295331
yup it is the build version
LVL 25

Expert Comment

ID: 20295341
another source which looks better. the key is that SPs are breakpoints. you must have that SP to install a particular KB

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how the fundamental information of how to create a table.

726 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