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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!