Post reply

SQL 2005 Express : service pack & default instance name

  • August 26, 2008 at 12:36 am

    #191656

    Dear all,

    I have the following questions on SQL Server 2005 Express Edition :

    (1)Can I apply the same Service Pack 2 and the Hot Fix ("the same" means the sp2 and sp2 hot fix being used by SQL 2005 Standard or Enterprise Editions) to SQL 2005 Express so that its version will become 9.0.3054 (now, it is only 9.0.3042) ?

    (2)The default instance name of SQL 2005 Standard or Enterprise Editions are the server's machine name, but in my newly installed SQL 2005 Express, the default instance name is \SQLExpress, is it normal ? Did my installation OK ?

  • August 26, 2008 at 12:43 am

    #862928

    onlo (8/26/2008)

    (2)The default instance name of SQL 2005 Standard or Enterprise Editions are the server's machine name, but in my newly installed SQL 2005 Express, the default instance name is \SQLExpress, is it normal ? Did my installation OK ?

    Perfectly normal. Express will always install with that instance name.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 26, 2008 at 12:50 am

    #862929

    Thanks, but can I also apply the same sp2 hot fix so that it becomes 9.0.3054 ?

Viewing 3 posts - 1 through 2 (of 2 total)

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