So I've just started up my most recent website: http://EpicClanWars.com
and it would seem that every 5th or 6th time I publish my project out of VS 2005 the Web.Config file corrupts and loses its connection string to the database and a nasty exception gets thrown stating that the web.config file does not contain the connection string that all of my SQLDataSource objects use.
I found this unanswered question that would also fix the issue: http://stackoverflow.com/questions/3389041/exclude-web-config-from-server-when-publishing-website-not-wap-vs2005
But I'd rather know if there were some sort of simple fix for this that I don't know about.