Results 1 to 2 of 2

Thread: Spid

  1. #1
    Join Date
    Nov 2003
    Location
    Mars
    Posts
    115

    Unanswered: Spid

    Hi All,
    Sql Server 7.

    I have a table cust_detail when ever there is an insert/update/delete in this table it is getting blocked and in turn its blocking other table inv_credit which is doing select statement.

    Please suggest me what might be the reason.

    Waiting for Reply
    TIA
    Adil

  2. #2
    Join Date
    May 2003
    Location
    Parsippany NJ
    Posts
    36
    Are you using Stored procedure to insert/update/delete that table. Maybe you could put lock hint to precent blocking. Say if you are doing select on that table, put with (nolock) hint. If you are deleting you could try rowlock or pagelock. But before putting all these lock hints. You still need to research why blocking is happening!

Posting Permissions

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