InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 22:35:07 GMT20http://www.sqlservercentral.com/Forums/Topic1064009-359-1.aspxHi,Can you please provide the script to send alerts for altering sql logins in sql server?Thu, 24 Feb 2011 05:33:09 GMTsanketahir1985http://www.sqlservercentral.com/Forums/Topic1064009-359-1.aspxI tried [b]select loginproperty('loginame','passwordlastsettime')As 'passwordlasttime'Its showing the last password change.Tue, 15 Feb 2011 23:02:18 GMTkommagonihttp://www.sqlservercentral.com/Forums/Topic1064009-359-1.aspxI 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 passwordTue, 15 Feb 2011 12:00:10 GMTPouliot Philippehttp://www.sqlservercentral.com/Forums/Topic1064009-359-1.aspxHi,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 meMon, 14 Feb 2011 22:36:17 GMTkommagoni