| Author: http://dotnetvj.blogspot.com 04 Jul 2008 | Member Level: Diamond | Rating:  Points: 4 |
Hi,
basically you need to have this functionaity at the user login time. After verifying the password, Look at the Password Modified date, when ever this date is oler than 10 days then send a singal to Front-end application and have the corresponding logic for this singnal in you application.
Thanks -- Vj
http://dotnetvj.blogspot.com
Thanks -- Vj
http://dotnetvj.blogspot.com
|
| Author: Bunty 04 Jul 2008 | Member Level: Diamond | Rating: Points: 3 |
Hi,
You can create stored procedure which execute automatically when SQL Server starts.
To run a stored procedure automatically,you have to create stored procedure in master database only..
Thanks and Regards
S.S.Bajoria
Thanks & Regards
S.S.Bajoria
|
| Author: Anithadevi 07 Jul 2008 | Member Level: Gold | Rating: Points: 4 |
set a field as expire date. when the user logged in once check the date with current date. if the difference is less than 5 give the user an intimation that the password is going to be expired in these many days.when they reset the password update the expiry date value as 10th
|