The MSDTC orphaned transactions hotfix was not included in CU8 which I had previously applied, but it did make it into CU9 for SQL 2005, so this should fix the...

chris.barrow (9/24/2008)

---

Ola Hallengren (9/24/2008)

---

I don't know about the root cause of the locking issue, but one thing that you could do to prevent the index optimization job from hanging is...

Ola Hallengren (9/24/2008)

---

I don't know about the root cause of the locking issue, but one thing that you could do to prevent the index optimization job from hanging is to...