none
SQL Server Version History

    Question

  • 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

    Friday, December 28, 2012 6:19 AM

Answers

  • 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:42 AM
  • 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 6:45 AM
  • 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.


    Friday, December 28, 2012 7:01 AM

All replies

  • 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:42 AM
  • 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 6:45 AM
  • 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.


    Friday, December 28, 2012 7:01 AM
  • 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

    Wednesday, January 02, 2013 12:24 AM