Re: SQL server 6.5 locks

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 07/30/04 

Date: Fri, 30 Jul 2004 08:54:30 +0530

Hi,

Exclusive locks will happen during a DML operations, such as INSERT, UPDATE,
or DELETE.
This ensure that multiple updates (changes) cannot be made to the same
resource at the same time. This lock will provide
the data integrity

How to remove it :-

It is not recommended to remove a Exclusive lock, this lock will removed as
soon as the operation is completed. If it is very urgent then
use the command

sp_who

to identify the process id and use the below command to remove the process

kill <spid>

This will kill the user before rolling back the transaction he did.

Thanks
Hari
MCDBA

.

"MeganE" <MeganE@discussions.microsoft.com> wrote in message
news:C5FEDBA5-108B-4DD5-963C-298E66179EC8@microsoft.com...
> I have an exclusive lock and I don't know how to remove it.