Post reply

Lock

  • May 9, 2008 at 5:47 am

    #190190

    i am using table to populate data for report purpose . if i launch same report from two clients this table always locked by another user. Am using primary key is newid() so it always different . how can i avoid this lock ? why one spid locking the another session though key is different ?

    Thanks in Advance .

  • May 9, 2008 at 6:01 am

    #812957

    The first direction I would go is to use a temp table rather than using an actual table. This would prevent your processes from running into each other.

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

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