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 insta开发者_JAVA百科nce? Is there a system table or view that stores that information?

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

http://support.microsoft.com/kb/321185

View installed updates should help determine that.

Control Panel\All Control Panel Items\Programs and Features and click on View Installed Updates

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')