Password change Date - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Password change Date

Author

Topic

MediaPirate
Yak Posting Veteran

52 Posts

Posted - 2004-12-28 : 09:11:30

Does anyone know how to pull from the syslogins table when passwords were last changed? The updatedate is to broad, I'd like to know if it's possible to just get the date the password was changed.

Thanks, Jim

nr
SQLTeam MVY

12543 Posts

Posted - 2004-12-28 : 11:09:14

Nope.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

Kristen
Test

22859 Posts

Posted - 2004-12-28 : 13:03:06

We store the syslogins password and date in a separate table - via a job that runs at midnight.


UPDATE U
SET    UpdateDate = GetDate(),
       MyPassword = password
FROM   MyTable U
       JOIN master.dbo.syslogins L
          ON U.uid = L.uid
WHERE     MyPassword <> password

and a similar INSERT statement that adds any "new" rows.

We then send out an email for anyone who's password is more than 30 days old asking them to change it, and an email to Admin for anyone who's password is more than 45 days old

Dunno if that sort of apprach would help you?

Kristen

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources