i need to be informed immediately once a deadlock happen
what the best practices for that ?
Can i use The Database Email with SQL server agent to notify me when deadlock occurs ? i already setup Database email and i use it from some purposes ...
again i need the best practices to be notified IMMEDIATELY because we are starting a new database Application and really i need it to handle any problem related to lock,deadlock