Post reply

SQL Server version

  • August 17, 2007 at 8:27 pm

    #121245

    Hi,

              I just installed SP2 on SQL Server 2005 developer edition. But after the installation i ran Select @@ version on the machine and it is showing me the same version (2005.090.1399). But if i check in the summary of the installion it is showing me the correct version. Also here i am attaching the log.Please help me why it is showing the old version.

    LOG

    ===

    Product                   : Database Services (MSSQLSERVER)

    Product Version (Previous): 1399

    Product Version (Final)   : 3042

    Status                    : Success

    Log File                  : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log

    Error Number              : 0

    Error Description         :

  • August 17, 2007 at 8:38 pm

    #727781

    Have restarted the windows server after installation SP2 ?

  • August 17, 2007 at 8:40 pm

    #727782

    Yes i restarted after the installation!

    After the restart also it is showing me the same..

  • August 18, 2007 at 5:39 am

    #727802

    if you connect to the database engine in management studio it will show the patch/sp level

    I'd suggest you re-install if the version is incorrect.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • August 20, 2007 at 4:18 am

    #727910

    yes, try doing the SP again on the server got the same error and fixed out retrying the same

Viewing 5 posts - 1 through 4 (of 4 total)

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