Probably not just a 2005 thing, but that's where the problem is.
A nightly load job sometimes fails because of locks held on a table by a suspended spid.
The hostname (sp_who or sysprocesses) for that spid is a laptop that is shut down.
How does that happen?
It may be significant that this application was not coded by a skilled programmer. It was kludgily
tossed together by clever business types from Access and Excel and god-knows-what. When it
got too big for Access, it was tossed into SQL Server, but the front end is still the kludgy stuff with
ad hoc access allowed by lots of people at all hours.