Marios.

Thanks for posting the MP and the relevant scripts.. It helped me a lot.

I also want to know if we can modify these scripts to alert on long running queries and locking queries.

If so, what is the SQL script that I have to use?

Please advise.

Thanks.

Srini.