Results 1 to 2 of 2

Thread: Record Locks

  1. #1
    Join Date
    Mar 2002

    Unanswered: Record Locks

    I am running into a problem where records are being locked out when I try to modify a record in SQL Server from Access. When I go into the "Locks by Process ID" and "Locks by Object" I do not see any locks for that table anywhere!?!? Is there another area in SQL Server where Locks can be managed?

  2. #2
    Join Date
    May 2002

    Re: Record Locks

    Try "sp_lock" to see what's going on.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts