February 14, 2011 at 10:36 pm
Hi,
I have created a DDL trigger that would send me a mail as soon as someone try to change the password of any login in SQL Server.I thought its very simple .The issue here is I am getting mail for all alter login event (for example if somebody changes the default database ,disable or enable the login etc). I want to filter it only to password change ,say if someone edits the password I need to get a notification.How to achieve it.Give me a full code for me
February 15, 2011 at 12:00 pm
I don't think you can do that. Maybe need more explication.The only password you can maybe track is SQL Account. You want verify for change after the first connection ? or any time the users can change her own password
February 15, 2011 at 11:02 pm
I tried select loginproperty('loginame','passwordlastsettime')As 'passwordlasttime'
Its showing the last password change.
February 24, 2011 at 5:33 am
Hi,
Can you please provide the script to send alerts for altering sql logins in sql server?
Sanket Ahir
Don't run behind the success, Try to be eligible & success will run behind u......
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply