We are seeing this issue even though the blocking spid (ReportServer.dbo.WriteLockSession;1) has 0 CPUTIme and 0 IO. Any ideas here?

Thanks!

Good work. Very useful script.

Thanks!

Change ODBC DSN setting to not use SQL native.

HTH

Hasn't this all been taken care of with DDL replication by setting the "Replicate Schema Changes” subscription property to "true" in 2005? Has been working for me up until it...

Come on guys!

How hard can it be?

Just like playing golf - swing, chase the ball... 🙂

Try creating a new project and adding the exported package to it in the solution explorer, it should enable debugging.