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.

All Forums  SQL Server 2005 Forums  Transact-SQL (2005)  SQL Deadlocks

Author  Topic  ekmatra Starting Member 1 Post Posted - 2011-02-28 : 04:35:11 Hi, Iam facing a this probelm first time ever. Having deadlocks every 15 mins or so. The problem here is the Object IDs in the deadlock trace are missing in sysObject. Are these ID of temporary objects ?? These are Object IDs and not HOTBT IDs. I don't know where should i begin looking for the source of problem because of these invalid IDs If anybody has come across such issue in the past. Please help. Regards, ekmatra