SQL 2008 R2 Issue

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Dixon
Posts: 2
Joined: Tue Oct 10, 2017 12:44 pm

SQL 2008 R2 Issue

Post by Dixon » 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?

Post Reply