david.r.nicholson (8/9/2010)
Could one of these dropped connections cause an index to get corrupted?
Unlikely (unless there's a bug in SQL 2000 that I've forgotten about). Vast majority of the time corruption is an IO subsystem problem.
Depends what corruption you're seeing. If it's torn pages or otherwise corrupt pages, it's likely IO subsystem. If it's invalid data (as Paul suggested), might be a bug in the ODBC driver or in SQL.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability