Disappearing database fields [Archive]

Click to See Complete Forum and Search --> : Disappearing database fields

jithu_hai

January 28th, 2006, 04:31 AM

Hi all

I am facing a peculiar problem.Every now andd then two of my table fields just disappear from my MSSQL table.I am not using alter table drop column and I have not done any DB restore.Still it happens .

Can anyone help

Sujith

exterminator

January 29th, 2006, 03:56 AM

Nothing happens without any reason. I am not very sure about how you do it in MySQL but you need to see the log file about the details. This must not happen on its own. Regards.

Krzemo

February 6th, 2006, 04:38 AM

Maybe U added column to table inside transaction, and U forgot to commit it.

Best regards,
Krzemo.