Thanks all.

I agree that it's bad idea to let them kill spids.

But we are not going to give it as it is. We are planning to develop a customized sproc and it will be given only to those chosen users who understand the criticality of it. We had implemented the same for one of client where we were supporting 5000+ servers and this issues used to come quite frequently. It was working fine. We are going to log all those as well.

Thanks again. 🙂