By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,973 Members | 1,242 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,973 IT Pros & Developers. It's quick & easy.

Question about Service Pack

P: n/a
In query analyzer

If I run this
SELECT @@version
I get this result
-------------------------------------------------------
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Personal Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
(1 row(s) affected)

If I run this
SELECT CONVERT(char(20), SERVERPROPERTY('ProductLevel'))
I get this result
--------------------
SP4

(1 row(s) affected)

What's the deal am I at SP2 or SP4?

Sep 4 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
You are running SQL Server 2000 SP4. The SP2 in the @@VERSION string is the
OS service pack level.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"SQL Server" <al*********@gmail.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...
In query analyzer

If I run this
SELECT @@version
I get this result
-------------------------------------------------------
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Personal Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
(1 row(s) affected)

If I run this
SELECT CONVERT(char(20), SERVERPROPERTY('ProductLevel'))
I get this result
--------------------
SP4

(1 row(s) affected)

What's the deal am I at SP2 or SP4?

Sep 4 '05 #2

P: n/a
Hi

To add to Dan's Reply:

Windows NT 5.1 (Build 2600: Service Pack 2)

Is Windows XP Service Pack 2.

A SQL Server version list can be found at:
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37

John
"SQL Server" <al*********@gmail.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...
In query analyzer

If I run this
SELECT @@version
I get this result
-------------------------------------------------------
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Personal Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
(1 row(s) affected)

If I run this
SELECT CONVERT(char(20), SERVERPROPERTY('ProductLevel'))
I get this result
--------------------
SP4

(1 row(s) affected)

What's the deal am I at SP2 or SP4?

Sep 4 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.