Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
suresha_b
Yak Posting Veteran
82 Posts |
 Posted - 2008-06-25 : 06:02:50
|
| select * from master.dbo.sysprocesseswhere blocked > 1is showing a spid blocked by same spid.sp_who is showing 3 rows for this spid with different ECID.The command running was alter index rebuild with (online = on)tempdb has 2 data files.SS2K5 x64 Enterprise edition.Server has 2 processors.Can a spid block itself? Is it a bug?kill is not ending it. How to fix this? |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2008-06-25 : 07:28:16
|
| Asked and answered:[url]http://www.sqlservercentral.com/Forums/Topic523132-146-1.aspx[/url]--Gail Shaw |
 |
|
|
|
|
|
Blocked by same SPID.