Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2014
    Posts
    1

    Unanswered: Does DBISQL GUI lock the database table?

    Hello there gents!

    At my place of employment, there is some heat coming from upper management stating that some of the employee's here are running a query on customer database's and leaving the DBISQL GUI open - which "locks the table".

    I'm 99.99% sure that the table is only locked during the execution time of that query (simple queries should be a few milliseconds).

    Please, as SQL masters, tell me if my management is out of it's mind, or is it true, that leaving an inactive instance of DBISQL after a query was performed can lock the table it last queried indefinitely (until DBISQL is closed).

  2. #2
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4
    You can test this, to be sure. Open 2 DBISQL-sessions, execute a typical query in one and leave the window open. Then execute sp_lock in the other window to see what locks are currently being held.
    I'm not crazy, I'm an aeroplane!

Posting Permissions

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