Results 1 to 4 of 4

Thread: SQL Server Table Lock

  1. Aug 14th, 2000, 03:21 AM #1
    tomtan
    tomtan is offline

    Thread Starter
    Member
    Join Date
    Jul 2000
    Location
    Singapore
    Posts
    39

    Question

    Hi,

    Anyone knows how to check whether a table is being lock by other users?

    If a user uses this query:

    BEGIN TRANSACTION
    UPDATE Table WITH(HOLDLOCK) SET Field = 'Test'

    How to know whether that table is Locked or not?

    Please help. Thanks
    ThOmaS TaN
    Reply With Quote Reply With Quote
  2. Aug 15th, 2000, 01:42 PM #2
    JHausmann
    JHausmann is offline
    Frenzied Member
    Join Date
    Aug 1999
    Location
    Santa Clara, Ca , 95058
    Posts
    1,105
    What DBMS are you using?
    Reply With Quote Reply With Quote
  3. Aug 15th, 2000, 08:35 PM #3
    tomtan
    tomtan is offline

    Thread Starter
    Member
    Join Date
    Jul 2000
    Location
    Singapore
    Posts
    39
    I'm using SQL Server 7.0.
    ThOmaS TaN
    Reply With Quote Reply With Quote
  4. Aug 15th, 2000, 11:00 PM #4
    Clunietp
    Clunietp is offline
    Guru Clunietp's Avatar
    Join Date
    Oct 1999
    Location
    USA
    Posts
    1,844
    check out Tablock
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width