Posted by Kevin Audleman on 02/24/06 21:42

I am using a hosted MSSQL 2000 database that powers the backend of my
website. Website visitors interact with it via ASP pages I have
developed. I also have an internal FileMaker 7 database that
periodically synchs with it via Filemaker's ODBC functionality.

Several times now, I have come in one day to discover that my ASP pages
don't work. When I look into it, one of my MSSQL tables will be missing
a few fields. There is nothing in any of my code that sends an ALTER
TABLE command or any other command that affects table structure. These
deletions of fields is totally random.

The most recent example was with a table called FreeTeacherSubs. I just
discovered today that three fields went missing:

HowDidYouHearAboutYES TEXT
FollowUpCallOrEmail TEXT
HowMaterialsFit TEXT

Suffice to say I am baffled! Has anyone ever experienced fields
disappearing from their tables?

Kevin

[Back to original message]