Forum Replies Created

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

  • RE: Global temporary table visibility

    AlwaysLoadingData (7/31/2015)

    I am using SQL 2008R2. I don't know if there have been changes in the lock scheduler that might make a difference.

    There was indeed a behavior change between SQL...

    July 31, 2015 at 5:51 pm

    #1816589

  • RE: Global temporary table visibility

    Jacob Wilkins (7/31/2015)

    3) While Query2 is running, closing Query1, where the global temp table was created. The session associated with Query1 requests a Sch-M lock on the temp table so...

    July 31, 2015 at 5:18 pm

    #1816587

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