Blocking

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

padhis SSCommitted Points: 1762 More actions · Answer 1

You can use below query to find out the current blocking transactions.

Select * from sys.sysprocesses where blocked<>0

If you are using Sql server 2005 or higher version then you can use standard reports for All blocking transactions.

Satya_0000 Mr or Mrs. 500 Points: 544 More actions · Answer 2

Thanks, but I am looking for an automated alert which will send the mail with blocking details.

padhis SSCommitted Points: 1762 More actions · Answer 3

Here is good article on this.

asheesh pandey Old Hand Points: 359 More actions · Answer 4

Check this link..