There is no really clean way to do this but if you check out hte
"LOCK_TIMEOUT setting" in BooksOnLine it gives a pretty good description of
a way that may be of use.
Andrew J. Kelly
SQL Server MVP
"basidati" <basidati.news.invalidweb2news.net> wrote in message
news:48191N976web2news.com...> How can i check if the record i want to select is already locked by
> another user? There is a way to know the resource id associated with the
> record in a table and compare that with those shown by the sp_lock?
> Direct access to this group with [url]http://web2news.com[/url]