Hello,

Thank-you for the replies and sorry for my late reply.

I finally got the answer from the client.

Just to let you know, I have told them the risks of killing a...

This implies that you're having locking problems. Is that the case? Usually, locking problems are as a result of poorly written queries and/or inadequate indexing. I strongly suggest you look...

Terry and Gail, Thank you for the reply

My role is Systems Engineer developing web apps mainly in C# .NET.

As both of you pointed out that killing SPIDs is not a...

I am creating a C# .NET web application that displays SPIDs that are

causing locks and let users to kill selected spids.

I just wanted hide their spid to prevent users from...