How to Find if locks exists when deleting records from a table

Hi,
Please do help me in finding whether any locks exists when records from a table is being removed(deleted).
I want a step by step procedure.
regards,
Raj
Hi,
1. Login to Query analyzer
2. Execute SP_WHO and identify the process id (SPID) in whcih you are
deleting the contents of table. Check for cmd column , it will show "DELETE"
3. After getting the SPID, Execute SP_LOCK <SPID> to get the lock
information
In the type column you will have diffrent types of lock types like;
DB = Database
IDX = Index
PG = PAGE
KEY = Key
TAB = Table
EXT = Extent
Thanks
Hari
MCDBA
"Raj" <anonymous@.discussions.microsoft.com> wrote in message
news:713607B3-ED2C-4FD6-8076-909FF3A8AF18@.microsoft.com...
> Hi,
> Please do help me in finding whether any locks exists when records from a
table is being removed(deleted).
> I want a step by step procedure.
> regards,
> Raj

How to Find if locks exists when deleting records from a table

Hi,
Please do help me in finding whether any locks exists when records from a ta
ble is being removed(deleted).
I want a step by step procedure.
regards,
RajHi,
1. Login to Query analyzer
2. Execute SP_WHO and identify the process id (SPID) in whcih you are
deleting the contents of table. Check for cmd column , it will show "DELETE"
3. After getting the SPID, Execute SP_LOCK <SPID> to get the lock
information
In the type column you will have diffrent types of lock types like;
DB = Database
IDX = Index
PG = PAGE
KEY = Key
TAB = Table
EXT = Extent
Thanks
Hari
MCDBA
"Raj" <anonymous@.discussions.microsoft.com> wrote in message
news:713607B3-ED2C-4FD6-8076-909FF3A8AF18@.microsoft.com...
> Hi,
> Please do help me in finding whether any locks exists when records from a
table is being removed(deleted).
> I want a step by step procedure.
> regards,
> Raj