The problem happens in Dev machine. Dev also has multiple other databases, and we have been writing TSQL code on it for a while, everything works fine. No red flags. ...
So far, they are all the same. So I don't understand. All the SQL Servers are 2005 with SP2. Originally it was SP1, so just to try, we installed SP2...