Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databases
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)
Post Follow-up to this message
Re: 2 different versions!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) > >
Post Follow-up to this message Re: 2 different versions!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] > >
Post Follow-up to this message Re: 2 different versions!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 > >
Post Follow-up to this message Re: 2 different versions!"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 --
Post Follow-up to this message RE: 2 different versions!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 Windo ws > NT 5.0 (Build 2195: Service Pack 4) > > >
Post Follow-up to this message Re: 2 different versions!> 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... > There diffrent because one is a kind of trial and the other is a full > verson > -- > EVAN > > > "Bob" wrote: >
Post Follow-up to this message
Sponsored Links
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread
