Friday, December 28, 2012 6:19 AM
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
Friday, December 28, 2012 6:42 AMAnswerer
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 HelperBlog Xing
Friday, December 28, 2012 6:45 AM
Look at the Summary.txt and your hotfix/service pack logs-
SQL Server setup log locations and more
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
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
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.
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
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