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')