Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Lock request time out period exceeded.

    I did this:

    1) start to rebuild index

    2) SP_WHO2

    the SP_WHO2 will show a row with column Command reading like "Rebuild Index"

    He will be getting blocked by a SPID.

    Kill that SPID.

    Kill him...

Viewing post 1 (of 1 total)