This is off the wall, but did "AUTO_CLOSE" somehow get set on for that db?
That's a longshot, since even if it did it should auto_open when you reference it, but I'm just trying to think of anything that could cause that.
SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.