how to determine date when service pack was applied to SQL Server instance?

Question

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?

Answer 1

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.