Post reply

Lock Request Timeout period Exceeded Error 1222

  • May 20, 2019 at 2:49 pm

    #3645412

    A long running job is doing a SELECT INTO a table, so the table gets created at the same time as it's being populated.

    If I try to expand the DB's list of tables, I get the error

    "Lock Request Timeout period Exceeded Error 1222"

     

    Is there a way to get around this ?

  • May 20, 2019 at 3:58 pm

    #3645449

    Do you mean expand the list in SSMS? No, the schema DMV is likely locked, and SSMS times out. You can create the table first, or you can try to query the DMV with nolock.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply