dbTalk Databases Forums  

Query Analyser for SQL Server 2000

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss Query Analyser for SQL Server 2000 in the microsoft.public.sqlserver.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Stephen Howe
 
Posts: n/a

Default Query Analyser for SQL Server 2000 - 06-20-2008 , 10:00 AM






Hi

2 questions:

1) It is possible to tell from "Help About" in QA for SQL Server 2000 which
service pack has been applied?
Note: I am _NOT_ talking about which SP has been applied to various SQL
Server 2000 servers (I know how that is done, I asked about 12+ months ago);
I am talking about QA itself. I am asking how you tell the SP applied to the
client tools installed.

2) I can see here
http://www.microsoft.com/downloads/d...displaylang=en
SQL Server 2000 SP4.

If I wished to update just the tools, do I need
SQL2000-KB884525-SP4-x86.EXE
or
SQL2000.AS-KB884525-SP4-x86.EXE
(or both?)

I think need the first file. It is that says "tools".

Thanks

Stephen Howe



Reply With Quote
  #2  
Old   
Rick Byham, \(MSFT\)
 
Posts: n/a

Default Re: Query Analyser for SQL Server 2000 - 06-20-2008 , 12:05 PM






When connected to a SQL Server
SELECT SERVERPROPERTY('PRODUCTVERSION') AS VersionNumber,
SERVERPROPERTY('PRODUCTLEVEL') AS ServicePack
returns something like:
VersionNumber ServicePack
---------------- -------------
8.00.2039 SP4
Since Help About on my Query Analyzer gives the version as SQL 8.00.2039 it
looks like the Query Analyzer version number will be the same as the service
pack number for the server.

The following table lists the Sqlservr.exe version number:Release
Sqlservr.exe
RTM 2000.80.194.0
SQL Server 2000 SP1 2000.80.384.0
SQL Server 2000 SP2 2000.80.534.0
SQL Server 2000 SP3 2000.80.760.0
SQL Server 2000 SP3a 2000.80.760.0
SQL Server 2000 SP4 2000.8.00.2039
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Stephen Howe" <stephenPOINThoweATtns-globalPOINTcom> wrote

Quote:
Hi

2 questions:

1) It is possible to tell from "Help About" in QA for SQL Server 2000
which service pack has been applied?
Note: I am _NOT_ talking about which SP has been applied to various SQL
Server 2000 servers (I know how that is done, I asked about 12+ months
ago); I am talking about QA itself. I am asking how you tell the SP
applied to the client tools installed.

2) I can see here
http://www.microsoft.com/downloads/d...displaylang=en
SQL Server 2000 SP4.

If I wished to update just the tools, do I need
SQL2000-KB884525-SP4-x86.EXE
or
SQL2000.AS-KB884525-SP4-x86.EXE
(or both?)

I think need the first file. It is that says "tools".

Thanks

Stephen Howe



Reply With Quote
  #3  
Old   
Rick Byham, \(MSFT\)
 
Posts: n/a

Default Re: Query Analyser for SQL Server 2000 - 06-20-2008 , 12:05 PM



When connected to a SQL Server
SELECT SERVERPROPERTY('PRODUCTVERSION') AS VersionNumber,
SERVERPROPERTY('PRODUCTLEVEL') AS ServicePack
returns something like:
VersionNumber ServicePack
---------------- -------------
8.00.2039 SP4
Since Help About on my Query Analyzer gives the version as SQL 8.00.2039 it
looks like the Query Analyzer version number will be the same as the service
pack number for the server.

The following table lists the Sqlservr.exe version number:Release
Sqlservr.exe
RTM 2000.80.194.0
SQL Server 2000 SP1 2000.80.384.0
SQL Server 2000 SP2 2000.80.534.0
SQL Server 2000 SP3 2000.80.760.0
SQL Server 2000 SP3a 2000.80.760.0
SQL Server 2000 SP4 2000.8.00.2039
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Stephen Howe" <stephenPOINThoweATtns-globalPOINTcom> wrote

Quote:
Hi

2 questions:

1) It is possible to tell from "Help About" in QA for SQL Server 2000
which service pack has been applied?
Note: I am _NOT_ talking about which SP has been applied to various SQL
Server 2000 servers (I know how that is done, I asked about 12+ months
ago); I am talking about QA itself. I am asking how you tell the SP
applied to the client tools installed.

2) I can see here
http://www.microsoft.com/downloads/d...displaylang=en
SQL Server 2000 SP4.

If I wished to update just the tools, do I need
SQL2000-KB884525-SP4-x86.EXE
or
SQL2000.AS-KB884525-SP4-x86.EXE
(or both?)

I think need the first file. It is that says "tools".

Thanks

Stephen Howe



Reply With Quote
  #4  
Old   
Rick Byham, \(MSFT\)
 
Posts: n/a

Default Re: Query Analyser for SQL Server 2000 - 06-20-2008 , 12:05 PM



When connected to a SQL Server
SELECT SERVERPROPERTY('PRODUCTVERSION') AS VersionNumber,
SERVERPROPERTY('PRODUCTLEVEL') AS ServicePack
returns something like:
VersionNumber ServicePack
---------------- -------------
8.00.2039 SP4
Since Help About on my Query Analyzer gives the version as SQL 8.00.2039 it
looks like the Query Analyzer version number will be the same as the service
pack number for the server.

The following table lists the Sqlservr.exe version number:Release
Sqlservr.exe
RTM 2000.80.194.0
SQL Server 2000 SP1 2000.80.384.0
SQL Server 2000 SP2 2000.80.534.0
SQL Server 2000 SP3 2000.80.760.0
SQL Server 2000 SP3a 2000.80.760.0
SQL Server 2000 SP4 2000.8.00.2039
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Stephen Howe" <stephenPOINThoweATtns-globalPOINTcom> wrote

Quote:
Hi

2 questions:

1) It is possible to tell from "Help About" in QA for SQL Server 2000
which service pack has been applied?
Note: I am _NOT_ talking about which SP has been applied to various SQL
Server 2000 servers (I know how that is done, I asked about 12+ months
ago); I am talking about QA itself. I am asking how you tell the SP
applied to the client tools installed.

2) I can see here
http://www.microsoft.com/downloads/d...displaylang=en
SQL Server 2000 SP4.

If I wished to update just the tools, do I need
SQL2000-KB884525-SP4-x86.EXE
or
SQL2000.AS-KB884525-SP4-x86.EXE
(or both?)

I think need the first file. It is that says "tools".

Thanks

Stephen Howe



Reply With Quote
  #5  
Old   
Rick Byham, \(MSFT\)
 
Posts: n/a

Default Re: Query Analyser for SQL Server 2000 - 06-20-2008 , 12:05 PM



When connected to a SQL Server
SELECT SERVERPROPERTY('PRODUCTVERSION') AS VersionNumber,
SERVERPROPERTY('PRODUCTLEVEL') AS ServicePack
returns something like:
VersionNumber ServicePack
---------------- -------------
8.00.2039 SP4
Since Help About on my Query Analyzer gives the version as SQL 8.00.2039 it
looks like the Query Analyzer version number will be the same as the service
pack number for the server.

The following table lists the Sqlservr.exe version number:Release
Sqlservr.exe
RTM 2000.80.194.0
SQL Server 2000 SP1 2000.80.384.0
SQL Server 2000 SP2 2000.80.534.0
SQL Server 2000 SP3 2000.80.760.0
SQL Server 2000 SP3a 2000.80.760.0
SQL Server 2000 SP4 2000.8.00.2039
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Stephen Howe" <stephenPOINThoweATtns-globalPOINTcom> wrote

Quote:
Hi

2 questions:

1) It is possible to tell from "Help About" in QA for SQL Server 2000
which service pack has been applied?
Note: I am _NOT_ talking about which SP has been applied to various SQL
Server 2000 servers (I know how that is done, I asked about 12+ months
ago); I am talking about QA itself. I am asking how you tell the SP
applied to the client tools installed.

2) I can see here
http://www.microsoft.com/downloads/d...displaylang=en
SQL Server 2000 SP4.

If I wished to update just the tools, do I need
SQL2000-KB884525-SP4-x86.EXE
or
SQL2000.AS-KB884525-SP4-x86.EXE
(or both?)

I think need the first file. It is that says "tools".

Thanks

Stephen Howe



Reply With Quote
  #6  
Old   
Rick Byham, \(MSFT\)
 
Posts: n/a

Default Re: Query Analyser for SQL Server 2000 - 06-20-2008 , 12:05 PM



When connected to a SQL Server
SELECT SERVERPROPERTY('PRODUCTVERSION') AS VersionNumber,
SERVERPROPERTY('PRODUCTLEVEL') AS ServicePack
returns something like:
VersionNumber ServicePack
---------------- -------------
8.00.2039 SP4
Since Help About on my Query Analyzer gives the version as SQL 8.00.2039 it
looks like the Query Analyzer version number will be the same as the service
pack number for the server.

The following table lists the Sqlservr.exe version number:Release
Sqlservr.exe
RTM 2000.80.194.0
SQL Server 2000 SP1 2000.80.384.0
SQL Server 2000 SP2 2000.80.534.0
SQL Server 2000 SP3 2000.80.760.0
SQL Server 2000 SP3a 2000.80.760.0
SQL Server 2000 SP4 2000.8.00.2039
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Stephen Howe" <stephenPOINThoweATtns-globalPOINTcom> wrote

Quote:
Hi

2 questions:

1) It is possible to tell from "Help About" in QA for SQL Server 2000
which service pack has been applied?
Note: I am _NOT_ talking about which SP has been applied to various SQL
Server 2000 servers (I know how that is done, I asked about 12+ months
ago); I am talking about QA itself. I am asking how you tell the SP
applied to the client tools installed.

2) I can see here
http://www.microsoft.com/downloads/d...displaylang=en
SQL Server 2000 SP4.

If I wished to update just the tools, do I need
SQL2000-KB884525-SP4-x86.EXE
or
SQL2000.AS-KB884525-SP4-x86.EXE
(or both?)

I think need the first file. It is that says "tools".

Thanks

Stephen Howe



Reply With Quote
  #7  
Old   
Rick Byham, \(MSFT\)
 
Posts: n/a

Default Re: Query Analyser for SQL Server 2000 - 06-20-2008 , 12:05 PM



When connected to a SQL Server
SELECT SERVERPROPERTY('PRODUCTVERSION') AS VersionNumber,
SERVERPROPERTY('PRODUCTLEVEL') AS ServicePack
returns something like:
VersionNumber ServicePack
---------------- -------------
8.00.2039 SP4
Since Help About on my Query Analyzer gives the version as SQL 8.00.2039 it
looks like the Query Analyzer version number will be the same as the service
pack number for the server.

The following table lists the Sqlservr.exe version number:Release
Sqlservr.exe
RTM 2000.80.194.0
SQL Server 2000 SP1 2000.80.384.0
SQL Server 2000 SP2 2000.80.534.0
SQL Server 2000 SP3 2000.80.760.0
SQL Server 2000 SP3a 2000.80.760.0
SQL Server 2000 SP4 2000.8.00.2039
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Stephen Howe" <stephenPOINThoweATtns-globalPOINTcom> wrote

Quote:
Hi

2 questions:

1) It is possible to tell from "Help About" in QA for SQL Server 2000
which service pack has been applied?
Note: I am _NOT_ talking about which SP has been applied to various SQL
Server 2000 servers (I know how that is done, I asked about 12+ months
ago); I am talking about QA itself. I am asking how you tell the SP
applied to the client tools installed.

2) I can see here
http://www.microsoft.com/downloads/d...displaylang=en
SQL Server 2000 SP4.

If I wished to update just the tools, do I need
SQL2000-KB884525-SP4-x86.EXE
or
SQL2000.AS-KB884525-SP4-x86.EXE
(or both?)

I think need the first file. It is that says "tools".

Thanks

Stephen Howe



Reply With Quote
  #8  
Old   
Rick Byham, \(MSFT\)
 
Posts: n/a

Default Re: Query Analyser for SQL Server 2000 - 06-20-2008 , 12:05 PM



When connected to a SQL Server
SELECT SERVERPROPERTY('PRODUCTVERSION') AS VersionNumber,
SERVERPROPERTY('PRODUCTLEVEL') AS ServicePack
returns something like:
VersionNumber ServicePack
---------------- -------------
8.00.2039 SP4
Since Help About on my Query Analyzer gives the version as SQL 8.00.2039 it
looks like the Query Analyzer version number will be the same as the service
pack number for the server.

The following table lists the Sqlservr.exe version number:Release
Sqlservr.exe
RTM 2000.80.194.0
SQL Server 2000 SP1 2000.80.384.0
SQL Server 2000 SP2 2000.80.534.0
SQL Server 2000 SP3 2000.80.760.0
SQL Server 2000 SP3a 2000.80.760.0
SQL Server 2000 SP4 2000.8.00.2039
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Stephen Howe" <stephenPOINThoweATtns-globalPOINTcom> wrote

Quote:
Hi

2 questions:

1) It is possible to tell from "Help About" in QA for SQL Server 2000
which service pack has been applied?
Note: I am _NOT_ talking about which SP has been applied to various SQL
Server 2000 servers (I know how that is done, I asked about 12+ months
ago); I am talking about QA itself. I am asking how you tell the SP
applied to the client tools installed.

2) I can see here
http://www.microsoft.com/downloads/d...displaylang=en
SQL Server 2000 SP4.

If I wished to update just the tools, do I need
SQL2000-KB884525-SP4-x86.EXE
or
SQL2000.AS-KB884525-SP4-x86.EXE
(or both?)

I think need the first file. It is that says "tools".

Thanks

Stephen Howe



Reply With Quote
  #9  
Old   
Rick Byham, \(MSFT\)
 
Posts: n/a

Default Re: Query Analyser for SQL Server 2000 - 06-20-2008 , 12:05 PM



When connected to a SQL Server
SELECT SERVERPROPERTY('PRODUCTVERSION') AS VersionNumber,
SERVERPROPERTY('PRODUCTLEVEL') AS ServicePack
returns something like:
VersionNumber ServicePack
---------------- -------------
8.00.2039 SP4
Since Help About on my Query Analyzer gives the version as SQL 8.00.2039 it
looks like the Query Analyzer version number will be the same as the service
pack number for the server.

The following table lists the Sqlservr.exe version number:Release
Sqlservr.exe
RTM 2000.80.194.0
SQL Server 2000 SP1 2000.80.384.0
SQL Server 2000 SP2 2000.80.534.0
SQL Server 2000 SP3 2000.80.760.0
SQL Server 2000 SP3a 2000.80.760.0
SQL Server 2000 SP4 2000.8.00.2039
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Stephen Howe" <stephenPOINThoweATtns-globalPOINTcom> wrote

Quote:
Hi

2 questions:

1) It is possible to tell from "Help About" in QA for SQL Server 2000
which service pack has been applied?
Note: I am _NOT_ talking about which SP has been applied to various SQL
Server 2000 servers (I know how that is done, I asked about 12+ months
ago); I am talking about QA itself. I am asking how you tell the SP
applied to the client tools installed.

2) I can see here
http://www.microsoft.com/downloads/d...displaylang=en
SQL Server 2000 SP4.

If I wished to update just the tools, do I need
SQL2000-KB884525-SP4-x86.EXE
or
SQL2000.AS-KB884525-SP4-x86.EXE
(or both?)

I think need the first file. It is that says "tools".

Thanks

Stephen Howe



Reply With Quote
  #10  
Old   
Rick Byham, \(MSFT\)
 
Posts: n/a

Default Re: Query Analyser for SQL Server 2000 - 06-20-2008 , 12:05 PM



When connected to a SQL Server
SELECT SERVERPROPERTY('PRODUCTVERSION') AS VersionNumber,
SERVERPROPERTY('PRODUCTLEVEL') AS ServicePack
returns something like:
VersionNumber ServicePack
---------------- -------------
8.00.2039 SP4
Since Help About on my Query Analyzer gives the version as SQL 8.00.2039 it
looks like the Query Analyzer version number will be the same as the service
pack number for the server.

The following table lists the Sqlservr.exe version number:Release
Sqlservr.exe
RTM 2000.80.194.0
SQL Server 2000 SP1 2000.80.384.0
SQL Server 2000 SP2 2000.80.534.0
SQL Server 2000 SP3 2000.80.760.0
SQL Server 2000 SP3a 2000.80.760.0
SQL Server 2000 SP4 2000.8.00.2039
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Stephen Howe" <stephenPOINThoweATtns-globalPOINTcom> wrote

Quote:
Hi

2 questions:

1) It is possible to tell from "Help About" in QA for SQL Server 2000
which service pack has been applied?
Note: I am _NOT_ talking about which SP has been applied to various SQL
Server 2000 servers (I know how that is done, I asked about 12+ months
ago); I am talking about QA itself. I am asking how you tell the SP
applied to the client tools installed.

2) I can see here
http://www.microsoft.com/downloads/d...displaylang=en
SQL Server 2000 SP4.

If I wished to update just the tools, do I need
SQL2000-KB884525-SP4-x86.EXE
or
SQL2000.AS-KB884525-SP4-x86.EXE
(or both?)

I think need the first file. It is that says "tools".

Thanks

Stephen Howe



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.