SQL 2005 Service Packs

[fuzzyocelot]

Hi everyone!

Is there a way to tell when a service pack was applied to SQL 2005?

Thanks!

 

[mrdenny]

Hunt down the log files that the service packs create. It should be in there.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[fuzzyocelot]

We tried looking for them, but couldn't find them. It was odd. We found the log files for a hotfix, though. Maybe someone deleted the log files for the service pack (SP2). It happens. Now that I know that's probably the way to look for them, I'll make a note of it.

Thanks!