Post reply

service pack 4

  • November 21, 2007 at 10:08 am

    #71013

    Hi,

    I have a small query:

    I am using SQL SERVER 2000 Standard Edition SP1 for both sql and analysis services.if I am upgrading my sql server 2000 from SP1 to SP4 means i am upgrading SQL SERVER 2000 Standard Edition to SQL SERVER 2000 ENTERPRISE EDITION?

  • November 21, 2007 at 10:25 am

    #753176

    If you are applying SP4, you will still be on Standard Edition. SP4 is a service pack upgrade. Going from Standard Edition to Enterprise Edition is a version upgrade. Does this make sense?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • November 21, 2007 at 3:18 pm

    #753226

    SP4 only brings you to build 8.00.2039. The latest hotfix/patch is 2187

  • November 22, 2007 at 12:29 am

    #753300

    SQL Server Standart Ed. and SQL Server Ent. Ed. are absolutely different products with different licenze fees and futures.

    The answer is NO

    Regards,

    Vidas

  • November 22, 2007 at 8:46 am

    #753430

    Hi Thanks for our reply..

    I have another small query

    when i fire the query select "@@version" the following is the result

    '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.2 (Build 3790: Service Pack 1)'

    Now when i fire the query "SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition') "the result is '8.00.760,SP3,Standard Edition'

    Here my query is my sql server 2000 is having now SP1 or SP3

  • November 23, 2007 at 2:29 am

    #753565

    Do not forget there are separate SP4 files for SQL Server and for AS. When you apply SP4 to SQL Server, you should also apply hotfix 2187 as there are some known issues in SP4 that 2187 fixes.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

  • November 23, 2007 at 8:08 am

    #753645

    Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)'

    That's the Windows Servicepack level. Your SQL Server build 8.00.760 means that the SQL SP version is 3.

    Markus

    [font="Verdana"]Markus Bohse[/font]

  • November 23, 2007 at 9:37 am

    #753669

    Hi All,

    Thanks for your reply

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply