Service Pack information

  • Dear All,

    How to check when service pack was applied on SQLServer2005?( Service pack wise)

    Thanks and Regards,

    Ravichandra.

  • SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

  • Thanks for the reply.

    But, I couldn't see any answer please.

    Regards,

    Ravichandra.

  • I don't believe there's any record within sQL as to when the patches are applied, just which one the system is running on.

    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
  • try this http://www.sqlservercentral.com/articles/Administration/2960/..might be helpfull

  • I think you can find the date and time from the summary file in

    C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG

    Thank You,

    Best Regards,

    SQLBuddy

  • Control Panel --> Add Remove Programs should have the date the SP was installed.

    MG

    "There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
    Tony Hoare

    "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.

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

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