I'm getting the same error and have it narrowed it down to an update statement. It's running on 2008 and updating via a linked server (2000), and if there are...
This has just occured to one of our databases that is log shipped. We too are running SQL 2005 SP2 (9.0.3054). I was able to just do a Transaction Log...