Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-12 : 09:37:15
|
| Geoffrey writes "On test upgrades I have been getting CHECKSUM errors on certain tables. On further investigation I cannot see any difference in the data between the original table and the upgraded table. Is there any code that can be run that will show were and what these errors are.Thank you for your help in this matter.Geoffrey Pitts" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-03-12 : 11:14:00
|
| You should run DBCC CHECKDB on all of your 6.5 databases to see if any errors are reported. There is an option on DBCC CHECKDB to fix errors, but I'm not sure of the exact syntax in 6.5 (Books Online will have it, read up on it first). You should also try performing a full database backup and restore and see if that alleviates the problem. |
 |
|
|
|
|
|
SQL 6.5 upgrade to SQL2000