Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Is there a utility to find out userID who is locking a record(page)

Status
Not open for further replies.

SrkrReds

Programmer
Dec 17, 2001
36
0
0
US
Hello:

Is there a utility(free ofcourse), that can be run against a database and findout who has placed a lock (and since access locks at 2k page levels, more than one record is locked) on a certain record OR is there some code somewhere that I can use to determine the userID locking the record?? Hopefully someone could help with the code, so we dont have to buy some COTs product. (suffering from budget constraints :) )

THanx in advance
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top