Steve & Nadrek,
I appreciate the information, but it still hasn't answered my question:
If I enable "check password expiration", when the account in question tries to login to the SQL server the next time, the user will be informed that their password has expired and must be changed, correct?
Again, I do appreciate the responses.