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 |
|
llahiff
Starting Member
6 Posts |
 Posted - 2005-09-09 : 13:06:54
|
| Hi Y'all!What would cause a sql server process to block itself? When I ran an sp_who or "select * from sysprocesses" it would show the process is blocking itself. Has anyone seen this behavior before?Thanks,Lorinda |
|
|
ryanston
Microsoft SQL Server Product Team
89 Posts |
Posted - 2005-09-09 : 13:12:21
|
| Likely the issue described here, if you're running SP4: http://www.mcse.ms/message1609509.html.Thanks,----------------------Ryan StonecipherDeveloper, Microsoft SQL Server Storage Engine, DBCC(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
 |
|
|
|
|
|
Self Blocking