Quote:Original post by nimrand
Also, most DB programmers I know avoid using AUTO_INCREMENT datatypes. MySQL might be different, but I know in MS Sequel Server, they can get currupt and are very difficult to fix if they do.
Could you give me some linkage on that? I have a MySQL database with 30 tables or so that all use AUTO_INCREMENT for their unique ID's. I need to move this database to MS-SQL in two weeks or so, so I would definately like to look up this snag.