Invaild column name

[Guest_imported]

Has anyone ever come accross this error message?

Microsoft SQL Server reported SQL message 207, severity 16: Invalid column name 'SerialNumber00'.

Basicly what is happening is it's not adding the column 'SerialNumber00' to the PC_BIOS_DATA table. I haven't created a custom "MIF" and I'm running service pack 3 everywhere.

 

[wardenlc]

I don't know if this is your problem or not, but if you create a MIF file with a Name=Something with a number of Attributes, you process the NoIDMiF, and then you add another Attribute, this will corrupt your database. Once the table definition has been created, another attribute cannot be added.

The best advice I can give when dealing with MIFs is to try things in a test environment first so that database corruption does not occur.

Hope it helps,
wardenlc

 

[Guest_imported]

Thanks. The problem I've got is that I didn't create a custom mif. This happen without any changes made.