I have a client looking to utilize SQL to email users when they have failed log in credentials 3 times. From what the client has told me, SQL should grab whatever user was attempting and email them that their account has entered credential wrong too many times. Client wants to use sp_send_dbmail The current expected results are as follows
- User enters password incorrectly 3 times
- SQL send email stating "User failed login too many times please reset password"
Is this achievable or is there something else that handles this type of query?