Forum Moderators: phranque
*Important* Make sure all the constraints/ relationships are properly copied across to the new server.
From what I remember (SQL 7) the setup script has to drop all the constraints for some reason and can be a little buggy.