Hi.



I am trying to solve the following problems:

We just upgraded our manufacturing software. Part of the conversion was moving from SQL Server 2005 to SQL Server 2008 R2. Now that the conversion is done, we are unable to see some of the fields that in tables we had seen before prior to the upgrade.

I think most of the fields in question are decimal datatypes with length of 13, precision of 20, and scale of 8.

The databases were moved from one server to another. Method of conversion was to backup the databases, then restore them onto the 2008 server. After that I changed the options from SQL 2005 to SQL 2008 R2.

If anyone can help me with this, I would greatly appreciate the help. Of if you would point me to some other resource (even paid would do at this point).

Thanks.