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 Saunders
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
|||John
Many thanks for your reply - this is excatly what I was looking for.
David Saunders
"John Bell" wrote:
[vbcol=seagreen]
> 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:

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

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 fro
m
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.aspf...-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 f
rom
> 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:
[vbcol=seagreen]
> Hi David
> I don't know if there is an installation date held in the registry, but fo
r
> SQL 2005 the installation log directory (...\90\Setup Bootstrap\LOG) may b
e
> an indication. For the current product verion use SELECT @.@.VERSION or use
> SERVERPROPERTY as described in
> http://sqlserver2000.databases.aspf...-m-running.html
> If you are running multiple instances on one machine you will need to chec
k
> each instance.
> John
>
> "David Saunders" wrote:
>sql

insisting on a password policy for sql

Is it possible to force users with sql accounts to use secure passwords say
6 plus characters long with numbers and letters. Is it also possible to have
sql insist that the passwords be changed every X days.
I am of course talking about when sql server 2000 uses sql authentication.
Please advise
AndreHi
SQL Server 2005 introduces this functionality.
Regards
--
Mike
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andre Gibson" <AndreGibson@.discussions.microsoft.com> wrote in message
news:8B9326C5-CF63-4609-A84D-4A596363A8EF@.microsoft.com...
> Is it possible to force users with sql accounts to use secure passwords
> say
> 6 plus characters long with numbers and letters. Is it also possible to
> have
> sql insist that the passwords be changed every X days.
> I am of course talking about when sql server 2000 uses sql authentication.
> Please advise
> Andre|||The short answer for SQL 2000 is No.
A much longer answer is that one could 'roll their own' and create some
overly complex custom functionality that most likely would still be
incomplete and fraught with problems.
Waiting for SQL 2005 -and lobbying for its' adoption, is the answer.
--
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another Certification Exam
"Andre Gibson" <AndreGibson@.discussions.microsoft.com> wrote in message
news:8B9326C5-CF63-4609-A84D-4A596363A8EF@.microsoft.com...
> Is it possible to force users with sql accounts to use secure passwords
> say
> 6 plus characters long with numbers and letters. Is it also possible to
> have
> sql insist that the passwords be changed every X days.
> I am of course talking about when sql server 2000 uses sql authentication.
> Please advise
> Andre