Installation Date/Version Numbers

Hi
I am very new to SQL Server and am trying to gain some general information
about it. What I am interetsed in is gaining either an installation date from
the software and/or a current version that is running? Is it possible to get
this information?
Many thanks,
David SaundersHi David
I don't know if there is an installation date held in the registry, but for
SQL 2005 the installation log directory (...\90\Setup Bootstrap\LOG) may be
an indication. For the current product verion use SELECT @.@.VERSION or use
SERVERPROPERTY as described in
http://sqlserver2000.databases.aspfaq.com/how-do-i-know-which-version-of-sql-server-i-m-running.html
If you are running multiple instances on one machine you will need to check
each instance.
John
"David Saunders" wrote:
> Hi
> I am very new to SQL Server and am trying to gain some general information
> about it. What I am interetsed in is gaining either an installation date from
> the software and/or a current version that is running? Is it possible to get
> this information?
> Many thanks,
> David Saunders|||John
Many thanks for your reply - this is excatly what I was looking for.
David Saunders
"John Bell" wrote:
> Hi David
> I don't know if there is an installation date held in the registry, but for
> SQL 2005 the installation log directory (...\90\Setup Bootstrap\LOG) may be
> an indication. For the current product verion use SELECT @.@.VERSION or use
> SERVERPROPERTY as described in
> http://sqlserver2000.databases.aspfaq.com/how-do-i-know-which-version-of-sql-server-i-m-running.html
> If you are running multiple instances on one machine you will need to check
> each instance.
> John
>
> "David Saunders" wrote:
> > Hi
> >
> > I am very new to SQL Server and am trying to gain some general information
> > about it. What I am interetsed in is gaining either an installation date from
> > the software and/or a current version that is running? Is it possible to get
> > this information?
> >
> > Many thanks,
> >
> > David Saunders