About Lockin in SQL Server

[dineshns]

How do i know weather specific record is locked or not using sp_lock or another way?

for Ex.
I have an Employees Table. When another user is editing Employee '001' record. Another user try to edit same record, need to check the lock status before start editing.

I use adLockPessiMistic to open employee table.

Thank u in advance,

dinesh

[hspc]

sp_lock can't do this...
but you can just handle the error that will raise if you try to open/update the locked record.