How long since binary (password) field changed?
Posted on 2006-03-21
In MS SQL Server 2000, a financial application database stores passwords in a table SY01400 as a binary field. The field is [SY01400.password].
PROBLEM: I would like a way to determine how long it has been since the password was changed, so that I can remind the user to change their password.
I've tried to create a temporary table to store the userid and password as of a given date, and then test at some later time to see if the password has changed in the SY01400 table.
However, any comparisons that I use don't detect changes in the password, because it's binary.