Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
SQL Server Version History

Answered SQL Server Version History

  • Friday, December 28, 2012 6:19 AM
     
     
    Sign In to Vote
    0

    Hi All

    I have a SQL Server 200 R2 instance that has been updated using several Microsoft updates over a period of time. The current version number is 10.50.1617.0 

    Is there a SQL Query or function that can be used to get a report of all the versions that my server was ever in and the date on which those versions came into effect

    Thanks in Advance

    pv


    pv

     

All Replies

  • Friday, December 28, 2012 6:42 AM
    Answerer
     
     Answered
    Sign In to Vote
    2

    Hello,

    No, there is no wa/query to get such version history. A good DBA notes when he updates/patches his SQL Server ... and updates are not done automatically by Windows LiveUpdate (of course), you have to select it as optional update.

    Olaf Helper

    Blog Xing

     
  • Friday, December 28, 2012 6:45 AM
     
     Answered
    Sign In to Vote
    2

    Look at the Summary.txt and your hotfix/service pack logs-

    SQL Server setup log locations and more

    http://blogs.msdn.com/b/arvindsh/archive/2008/12/22/sql-server-setup-log-locations-and-more.aspx

    Ofcourse look at the summary.txt(to check all the installations passed status)-

    How to identify SQL Server 2008 setup issues in the setup log files
    http://support.microsoft.com/kb/955396


    Thanks, Rama Udaya.K (http://rama38udaya.wordpress.com) ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.

     
  • Friday, December 28, 2012 7:01 AM
     
     Answered
    Sign In to Vote
    2

    Assuming you installed an RTM instance (not CTP or any other pre-release) for SQL 2008 R2, you have only one update applied on your SQL server thus far i.e. a security update.

    Refer to http://support.microsoft.com/kb/2494088 for more details.

    RTM version = 10.50.1600

    Security update KB2494088 = 10.50.1617

    Pls refer to http://sqlserverbuilds.blogspot.in/ to know aboue different builds and related KB articles.

    HTH

    This posting is provided “AS IS” with no warranties, and confers no rights.

    If this reply answers your question, please mark it as Answered for others to find it easily.
    If this reply help you resolving the problem, please vote the post as Helpful.


     
  • Wednesday, January 02, 2013 12:24 AM
     
     
    Sign In to Vote
    0

    Hi there,

    SQL server do not maintain by default any table to hold that information as that of i know. But you can maintain that information in a user defined table in system databases if you wanted.

    check the below link, that tells you what you have on your server.  connect to SSMS and use: select @@version

    http://www.sqlteam.com/article/sql-server-versions

    thanks

    kumar