how to determine date when service pack was applied to SQL Server instance?
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?
3 Solutions collect form web for “how to determine date when service pack was applied to SQL Server instance?”
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.
Please refer following link
Where you understand
How to determine the version and edition of SQL Server and its components
View installed updates should help determine that.
Control Panel\All Control Panel Items\Programs and Features and click on View Installed Updates