Password Change Date

Is there a way to retreive the date and time when a user last time changed
his/her SQL password? I am using SQL 2000/SQL Server Authentication.
TIA
SorinHi,
SQL Server will not store those information.
Thanks
Hari
SQL Server MVP
"SOPONL" <SOPONL@.discussions.microsoft.com> wrote in message
news:65DF9A86-8711-404D-B6C9-930113378751@.microsoft.com...
> Is there a way to retreive the date and time when a user last time changed
> his/her SQL password? I am using SQL 2000/SQL Server Authentication.
> TIA
> Sorin|||Check out the updatedate column in syslogins. Other changes might change thi
s as well, like changing
default language or default database, but I doubt that you do that very ofte
n.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"SOPONL" <SOPONL@.discussions.microsoft.com> wrote in message
news:65DF9A86-8711-404D-B6C9-930113378751@.microsoft.com...
> Is there a way to retreive the date and time when a user last time changed
> his/her SQL password? I am using SQL 2000/SQL Server Authentication.
> TIA
> Sorin