For an instance of SQL Server 2005/2008, how can one determine the date and time when a service pack was applied to the instance? Is there a system table or view that stores that information?
+2
A:
Look into C:\Program Files\Microsoft SQL Server\XXX\Setup Bootstrap\Log. The summary.txt and the individual SP log folders have all the details.
Remus Rusanu
2010-06-01 19:03:01