I have encountered a slight problem restoring a SQL Server 7 database to Server 2000.
In some of the tables, all records are duplicated.
When I try to delete them naturally I get an error "Too many rows were affected by update". What are my options here?
If you're sure the duplicates can be removed perhaps you could either do a insert distinct into a new table and rename it if there are no indexes etc involved. Or, add a new integer column, fill it with a unique value and then delete the doubles. Or, create a cursor that 'walks' through the table and delete the the current (not sure if this will work though).