Alert mechanism if there is a particular login attempted in SQL server
Posted on 2016-10-25
Is there any way i could get alert from SQL server if the particular login is attempted in SQL server?
Eg., particular User named "Robin" attempts to login SQL server , then can i setup an Alert mechanism which should send an email to me stating "Robin" has logged in to our database server.
If yes, please share me the scripts/steps to setup the same.
Note: My environment running with SQL server 2008 R2 service pack 2 enterprise edition.