Viewing post 1 (of 1 total)
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...
August 4, 2011 at 12:50 pm
#1363902