Table and its Records disapear without a trace

[atran6]

Dear All:

I need your help on SQL Server 7.0 Standard.

The machine is WindowsNT40 Server, service
pack 6, installed Visual Basic, service pack
4.

I can create new database, new table, new
records, edit them, or delete them. I can
do all these tasks by Enterprise Manager,
or Query Analyser, or Visual Basic program
I write.

The machine is off all day long, and is on
only few hours when I come home from work.

What surprises me is that when I open SQL
Server again, the database I created is there
but the table and all records are gone!!

This occurs 3 times, and all my codes are
there, and I can run them over and over
again many times. I wonder why the table I
created and all records disappear?

Please, if you have time, just discuss the
topic, no matter your know the explanation
or not.

Your effort is appreciated.
Have a nice day.
Yours truly,
AnhMy Tran.

 

[mfairchild]

I assume you don't have a "#" in front of the table name.

 

[atran6]

Thank you for your help.

No. My table have a name with DOS format,
that has no special character.

After reading your email, I add the #
infront of the table name, but think
cannot get different.

Have a nice day.