find the date a sp was installed

hi,
i know how to check what version of service pack i have installed on
sql server 2000...but does anyone know how to find out the date it was
installed on.
i am having probs with sql server agent and can see the date the probs
started...and think it was about the time sp4 was installed but am not
sure.
thanks..
> i know how to check what version of service pack i have installed on
> sql server 2000...but does anyone know how to find out the date it was
> installed on.
Maybe the sp setup log file is still under the windows directory somewhere?
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
|||hi aaron,
what is this setup file called..and in which directory would it be. i
looked in the default sql server log folder and can see no set file.
thanks...
On Feb 28, 3:45 pm, "Aaron Bertrand [SQL Server MVP]"
<ten...@.dnartreb.noraa> wrote:
> Maybe the sp setup log file is still under the windows directory somewhere?
> --
> Aaron Bertrand
> SQL Server MVPhttp://www.sqlblog.com/http://www.aspfaq.com/5006
|||Search %windir% recursively for *.log files. I don't use SQL Server 2000
anymore so I'm not too familiar with the exact path SP4 happened to use.
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
<kieran5405@.hotmail.com> wrote in message
news:1172678113.473947.250540@.s48g2000cws.googlegr oups.com...
> hi aaron,
> what is this setup file called..and in which directory would it be. i
> looked in the default sql server log folder and can see no set file.
> thanks...
|||<kieran5405@.hotmail.com> wrote in message
news:1172676833.093383.37040@.m58g2000cwm.googlegro ups.com...
> hi,
> i know how to check what version of service pack i have installed on
> sql server 2000...but does anyone know how to find out the date it was
> installed on.
>
I'd do a select * from sysobjects in the master DB and look at the date of
some of the system stored procs. I'm pretty sure there's a bunch replaced
there which will have their creation date listed.

> i am having probs with sql server agent and can see the date the probs
> started...and think it was about the time sp4 was installed but am not
> sure.
> thanks..
>
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com
|||hi guys,
cheers for that...
i did the select statement and for the returned field 'crdate' - which
i presume means created date...i see the same date repeatedly listed
that sql agent stopped working. i can only conclude that after
installing sp4...the agent stopped working.
when i now try and start the agent i get the error message -
error 32 - the process could not access the file because it is been
used by another process.
does anyone have any ideas how i could fix this or this would be
happening with sp4
thanks...
On Feb 28, 4:13 pm, "Greg D. Moore \(Strider\)"
<mooregr_deletet...@.greenms.com> wrote:
> <kieran5...@.hotmail.com> wrote in message
> news:1172676833.093383.37040@.m58g2000cwm.googlegro ups.com...
>
> I'd do a select * from sysobjects in the master DB and look at the date of
> some of the system stored procs. I'm pretty sure there's a bunch replaced
> there which will have their creation date listed.
>
> --
> Greg Moore
> SQL Server DBA Consulting
> sql (at) greenms.com http://www.greenms.com
|||I tracked down a system that had SP4 and a post-SP4 hotfix applied, and
found the following files:
8.00.2039
C:\Windows\sqlsp.log
8.00.2187
C:\Windows\SQL2000-KB916287-v8.00.2187-x86-ENU.log
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
<kieran5405@.hotmail.com> wrote in message
news:1172676833.093383.37040@.m58g2000cwm.googlegro ups.com...
> hi,
> i know how to check what version of service pack i have installed on
> sql server 2000...but does anyone know how to find out the date it was
> installed on.
> i am having probs with sql server agent and can see the date the probs
> started...and think it was about the time sp4 was installed but am not
> sure.
> thanks..
>