January 31, 2005 at 9:55 am
I have a SQL Job that keeps locking.
After further investigation using sp_lock and master.dbo.sysLockinfo, it seems to be waiting to get a
Exclusive Page Lock on Object ID of 0.
Cannot find what object has an ID of 0.
List of Locks for the process.
| SPID | DBID | ObjID | Type | Mode | Status |
| 61 | 7 | 1127727120 | Table | IX | Granted |
| 61 | 7 | 0 | Extent | X | Granted |
| 61 | 7 | 0 | Index | X | Granted |
| 61 | 7 | 0 | DB | S | Granted |
| 61 | 7 | 0 | Page | X | Granted |
| 61 | 7 | 0 | Page | X | Waiting |
Does anyone know what an object id 0 means?
February 1, 2005 at 11:18 am
I'd be interested as well.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
February 1, 2005 at 3:45 pm
Basically whenever you see and ObjID of 0 it indicates an object for which there is no concept in sysobjects. Thus, databases, indexes, pages, extents, etc... will always have an ObjID of 0.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply