Can I tell when SQL Server was upgraded?

Unusal question but I am trying to find out the date an instance of SQL
Server was upgraded from 7.0 to 2000.
It was probably about 6 months ago and I am trying to pin it down to a
specific date.
I thought that maybe the creation date of system tables in msdb or Master
would give me a clue but they all seem to be 8/6/2000 which is definitely
not correct.
The logs have long since recycled.
Does anyone have any other ideas?Wild guess, but search for iss files (the install directory for your
instance). I'm thinking that the upgrade will produce an ISS file and the
date for this can be the answer. My machine shows 2002-08-06 for my sp1
instance and 2003-03-22 for my sp3 instance. Note that the machine was most
probably installed after sp1 was released but before sp3 ...
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"DaveF" <davef@.comcast.net> wrote in message
news:efck5Xj%23DHA.2808@.TK2MSFTNGP10.phx.gbl...
> Unusal question but I am trying to find out the date an instance of SQL
> Server was upgraded from 7.0 to 2000.
> It was probably about 6 months ago and I am trying to pin it down to a
> specific date.
> I thought that maybe the creation date of system tables in msdb or Master
> would give me a clue but they all seem to be 8/6/2000 which is definitely
> not correct.
> The logs have long since recycled.
> Does anyone have any other ideas?
>
>|||You can also try looking for sqlstp.log which I think is in c:\winnt by
default.
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"DaveF" <davef@.comcast.net> wrote in message
news:efck5Xj%23DHA.2808@.TK2MSFTNGP10.phx.gbl...
> Unusal question but I am trying to find out the date an instance of SQL
> Server was upgraded from 7.0 to 2000.
> It was probably about 6 months ago and I am trying to pin it down to a
> specific date.
> I thought that maybe the creation date of system tables in msdb or Master
> would give me a clue but they all seem to be 8/6/2000 which is definitely
> not correct.
> The logs have long since recycled.
> Does anyone have any other ideas?
>
>