November 29, 2006 at 7:41 am
Hello,
MSSQL 2000/Win2003
Is there a way to determine when (date) a SQL Sever service pack was installed or upgraded?
Many thanks. Jeff
November 29, 2006 at 8:03 am
May i ask you to look at sqlsp.log file under C:\WINDOWS folder? Creation datetime would give you information which you need.
My assumption is that no one modified this file.
if you don't recycle Applicaiton log, you can look for First startup of SQL Server with the service pack build. (search for 8.00.760 for SP3 etc)
November 29, 2006 at 9:42 am
Excellent. Thanks.
Any thoughts on how to capture the sqlsp.log date in a sql statement? I would like to create a report using sp_sendmail with @@version and date of the sqlsp.log?
Many thanks. Jeff
November 29, 2006 at 3:38 pm
Exec xp_cmdshell
'dir C:\WINDOWS\sqlsp.log'
it will return several lines including the date on the file. It will work on SQL Server 2000 computers and will not work on SQL Server 2005 with different log files location and names.
Regards,Yelena Varsha
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply