How to create Blocking alert and generate e-mail alert.

Being SQL DBA it’s one of Important task to have real time blocking alert on server. This example demonstrate how to configure blocking alert and capture blocking Step 1 – Create SP to check blocking log – This SP will help to identify blocking on server with specific time ( in this example it’s for 2… Read More How to create Blocking alert and generate e-mail alert.