?
Solved

what is "Microsoft SQL Server  2000 - 8.00.2189"

Posted on 2007-11-15
5
Medium Priority
?
296 Views
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:http://sqlserverbuilds.blogspot.com/
I dont see a SP for 8.00.2189.

What SP is that?
0
Comment
Question by:Camillia
[X]
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
5 Comments
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 1000 total points
ID: 20295253
Hello Farzadw,

select serverproperty('productLevel')




Aneesh R
0
 
LVL 7

Author Comment

by:Camillia
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....build number?
0
 
LVL 25

Assisted Solution

by:imitchie
imitchie earned 1000 total points
ID: 20295301
0
 
LVL 75

Expert Comment

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

Expert Comment

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

http://sqlserverbuilds.blogspot.com/
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how the fundamental information of how to create a table.

770 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