| Author |
2 different versions!
|
|
|
| We have two database servers. Apparently they are running two different
versions of SQL Server 2000. Can someone tell me what are the differences
between the two versions?
Server 1
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows
NT 5.0 (Build 2195: Service Pack 4)
Server 2
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
NT 5.0 (Build 2195: Service Pack 4)
| |
| Hari Prasad 2005-10-29, 7:23 am |
| Hi,
8.00.760 > 2000 SP3/SP3a
8.00.2039 > 2000 SP4 ** (Recommended Patch Level)
See the below URL:-
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37
Thanks
Hari
SQL Server MVP
"Bob" <spamfree@nospam.com> wrote in message
news:u5lAZAF3FHA.3776@TK2MSFTNGP10.phx.gbl...
> We have two database servers. Apparently they are running two different
> versions of SQL Server 2000. Can someone tell me what are the differences
> between the two versions?
>
> Server 1
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows
> NT 5.0 (Build 2195: Service Pack 4)
>
> Server 2
> Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
> Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on
> Windows
> NT 5.0 (Build 2195: Service Pack 4)
>
>
| |
|
| Thanks for your reply.
Something is not right. Our Windows 2000 Servers are all patched with SP4.
So, I don't understand why that info says it is "2000 SP3/SP3a".
Any idea how I can update 8.00.760 to 8.00.2039?
Thanks again.
"Hari Prasad" < hari_prasad_k@hotmai
l.com> wrote in message
news:OYQmvyG3FHA.3844@TK2MSFTNGP10.phx.gbl...
> Hi,
>
> 8.00.760 > 2000 SP3/SP3a
>
> 8.00.2039 > 2000 SP4 ** (Recommended Patch Level)
>
> See the below URL:-
>
> http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37
>
> Thanks
> Hari
> SQL Server MVP
>
>
>
> "Bob" <spamfree@nospam.com> wrote in message
> news:u5lAZAF3FHA.3776@TK2MSFTNGP10.phx.gbl...
differences[color=da
rkred]
Windows[color=darkre
d]
23:18:38[color=darkr
ed]
>
>
| |
| Tom Moreau 2005-10-29, 11:23 am |
| He means SP4 for SQL Server - not Windows.
--
Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
"Bob" <spamfree@nospam.com> wrote in message
news:%23CdUqYJ3FHA.732@TK2MSFTNGP10.phx.gbl...
> Thanks for your reply.
>
> Something is not right. Our Windows 2000 Servers are all patched with
> SP4.
> So, I don't understand why that info says it is "2000 SP3/SP3a".
>
> Any idea how I can update 8.00.760 to 8.00.2039?
>
> Thanks again.
>
>
> "Hari Prasad" < hari_prasad_k@hotmai
l.com> wrote in message
> news:OYQmvyG3FHA.3844@TK2MSFTNGP10.phx.gbl...
> differences
> Windows
> 23:18:38
>
>
| |
| David Portas 2005-10-29, 11:23 am |
| "Bob" <spamfree@nospam.com> wrote in message
news:%23CdUqYJ3FHA.732@TK2MSFTNGP10.phx.gbl...
> Thanks for your reply.
>
> Something is not right. Our Windows 2000 Servers are all patched with
> SP4.
> So, I don't understand why that info says it is "2000 SP3/SP3a".
>
> Any idea how I can update 8.00.760 to 8.00.2039?
>
> Thanks again.
>
>
> "Hari Prasad" < hari_prasad_k@hotmai
l.com> wrote in message
> news:OYQmvyG3FHA.3844@TK2MSFTNGP10.phx.gbl...
> differences
> Windows
> 23:18:38
>
>
Not Windows 2000 SP4. SQL Server SP4.
See:
http://www.microsoft.com/sql/downloads/2000/sp4.mspx
--
David Portas
SQL Server MVP
--
| |
|
| There diffrent because one is a kind of trial and the other is a full verson
--
EVAN
"Bob" wrote:
> We have two database servers. Apparently they are running two different
> versions of SQL Server 2000. Can someone tell me what are the differences
> between the two versions?
>
> Server 1
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows
> NT 5.0 (Build 2195: Service Pack 4)
>
> Server 2
> Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
> Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
> NT 5.0 (Build 2195: Service Pack 4)
>
>
>
| |
| Dan Guzman 2005-10-29, 8:23 pm |
| > There diffrent because one is a kind of trial and the other is a full
> verson
The build numbers will be the same on different SQL Server editions as long
as the same SQL service packs/hotfixes are applied. It looks like Bob is
running SP3 on the Standard instance and SP4 on the Enterprise instance.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Evan" <Evan@discussions.microsoft.com> wrote in message
news:B4711381-786E-424D-BCE6- 9653AF536D87@microso
ft.com...[color=darkred]
> There diffrent because one is a kind of trial and the other is a full
> verson
> --
> EVAN
>
>
> "Bob" wrote:
>
|
|
|
|