SQL Server Version Numbers -- sql server (microsoft)

david.e.macaskill NO[at]SPAM honeywell.com
11/13/2003 7:05:03 AM

Does this strike you as odd? If I run SELECT @@VERSION I get:

Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000
00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Developer
Edition on Windows NT 5.0 (Build 2195: Service Pack 3)

What leaps out at me is the "Server Pack 3" at the end. So at first
glance I thought - I've got SP3. But if I run SELECT
SERVERPROPERTY('ProductLevel') I get:

RTM

According to MS documentation, I have just the original release -

SQL Server 2000 version and level @@VERSION ProductLevel
SQL Server 2000 Original Release 8.00.194 RTM
Database Components SP1 or 8.00.384 SP1
Desktop Engine SP1
Database Components SP2 or 8.00.534 SP2
Desktop Engine SP2
Database Components SP3 or SP3a, or 8.00.760 SP3
Desktop Engine SP3 or SP3a

fa99tty NO[at]SPAM hotmail.com
11/14/2003 12:07:20 PM

I believe that is SP3 for the OS, not SQL.

On 13 Nov 2003 07:05:03 -0800, david.e.macaskill@honeywell.com (David
[quoted text, click to view]

BrianB
11/26/2003 9:26:11 AM

the service pack 3 indication is for the OS (NT 5.0), the SQL service pack
is indicated within the version number, 8.00.194, the 194 indicates no
service packs have been installed. the service pack revision numbers are;
8.00.194, 8.00.384 (SP1), 8.00.534 (SP2), 8.00.760 (SP3/SP3a)

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server (microsoft)

sql server (microsoft) : SQL Server Version Numbers