SQL 2008 R2 Issue
Posted: Wed Oct 31, 2012 11:08 pm
We were using v10 running on SQL2000. There is a field in the SQL table called GameRowID that is defined as Numeric with a length of 9. The field is crucial as it is a base for many calculations. When the database was updated to SQL2008R2 we tried opening a report and got an error stating "Character field ^GameRowID^ is no longer in table ^tblResults^". I checked the table and the field is there, but SQL2008 changed it to varcar. I altered the table and changed the data type to Numeric(18,0) which looks like my only numeric choice, but have the same issue. I also tried Int with the same result. Is there a way around this?