Results 1 to 3 of 3

Thread: MS SQL table locked - [RESOLVED]

  1. Jan 16th, 2004, 07:00 AM #1
    mik706
    mik706 is offline

    Thread Starter
    Addicted Member
    Join Date
    Jul 2002
    Location
    UK
    Posts
    147

    MS SQL table locked - [RESOLVED]

    i was wondering what would happen if you tried to access a table in MS SQL which had already been locked by another process. Would it generate an error or just hold the process off untill the table was unlocked?
    Last edited by mik706; Jan 16th, 2004 at 07:51 AM.
    Mik706
    Reply With Quote Reply With Quote
  2. Jan 16th, 2004, 07:43 AM #2
    mendhak
    mendhak is offline
    I'm about to be a PowerPoster! mendhak's Avatar
    Join Date
    Feb 2002
    Location
    Ulaan Baator GooGoo: Frog
    Posts
    38,170
    Depends upon the lock type, and what you're doing. If you're trying to edit what the other user's editing, an error is raised. You can handle that error.
    Reply With Quote Reply With Quote
  3. Jan 16th, 2004, 07:51 AM #3
    mik706
    mik706 is offline

    Thread Starter
    Addicted Member
    Join Date
    Jul 2002
    Location
    UK
    Posts
    147
    I am locking the table pessimistically to insert rows. So I assumed that if another app tried to insert rows whilst the table is locked it would generate an error, I was just having problems proving it.
    Mik706
    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