Urgent help please!

Recently we had a blocking issue that stops all application.

Does anyone has a script that can be run as a job to periodically check the blocking issues and then notify throuht e-mail?

If not how can i check the blocking issues periodically?

Thanks

Refer to this link:

http://support.microsoft.com/search...us;Q271509

You can also use profiler to find out what's blocking. Or, you can also use a combination of executing sp_who2 'active' and dbcc inputbuffer to find out what the blocking spid is doing.

Alan

dbcc traceon(1204,1205, 3605)