Good morning everyone,

I'm trying to formulate a script that will 'automatically' kill this
process that blocks other users from running commands against the database.
Of course, this will be a temporary fix, until we redesign the database
structure.

Any ideas or suggestions that you may have will be much appreciated.

Thank you,

Pete.:)

Peter M. Florenzano
Database Administrator
Distributed Computing
Email: Peter.[Email address protected]
Phone: (203)752-4317



CONFIDENTIALITY NOTICE: This message and any attachments may contain confidential, proprietary or legally privileged information and is intended only for the use of the addressee or addressees named above for its intended purpose. If you are not the intended recipient of this message, this message constitutes notice that any review, retransmission, distribution, copying or other use or taking any action in reliance on the information in this message and its attachments, is prohibited. If you receive this communication in error, please immediately advise the sender by reply e-mail and delete this message and its attachments from your system without keeping a copy. Unless expressly stated in this e-mail, nothing in this message may be construed as a digital or electronic signature. Thank you.

MS Sql Server LazyDBA home page