This can happen if the website is being "hacked". This is done via SQL
Injection, where by DDL language is used in the fields that are on the
screen. With the clever use of quotes and semi-colons, a hacker can issue a
TRUNCATE TABLE or DROP table.
Oscar...
"Len Svitenko" <it******************@yahoo.com> wrote in message
news:60**************************@posting.google.c om...
I have a client running SQL server 2000 on Windows 2003. Yesterday
data just started disappearing. It is being accessed by asp via his
website and when the data is being inserted it seems to all of a
sudden drop all data in the table. Earlier in the day the table
disappeared all together. Anyone ever see this?
LS