Home > IT Answers > SQL Server > Is there a way to find out when a patch was last applied to an instance?
Mrhr2461
20 pts.
 Is there a way to find out when a patch was last applied to an instance?
SQL instance, SQL Server, SQL Server security, SQL Server User Instances
Is there a way to find out the date a SQL Server instance was last patched?  I need to keep track of dates each of my instances had a patch applied whether it be a security patch, hotfix or service pack.  I looked in the ServerProperty function but did not see anything that would return this information.  Any insights on how to get this info from SQL 2000, 2005 or 2008 would be greatly appreciated.

Thanks.



Software/Hardware used:
ASKED: October 4, 2011  2:20 PM
UPDATED: March 31, 2012  12:43 AM
RELATED QUESTIONS
Answer Wiki:
As far as I know your only option there would be to look at the add/remove programs list (or dump this data from the registry to make it easier to deal with) and get that info from there. SQL Server doesn't track that within the system databases.
Last Wiki Answer Submitted:  October 4, 2011  5:56 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Do you know what registry key this data would be found under?

Mrhr2461
 20 pts.
 

I would start my research with this Microsoft article

How to determine the version and edition of SQL Server and its components

and this link

http://support.microsoft.com/default.aspx?scid=kb;en-us;q321185

I think Mr Denny probably has the right answer for you though.

James Murray
 1,795 pts.