Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    35

    Unanswered: Restore from v7 to 2000 ?

    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?

  2. #2
    Join Date
    Feb 2004
    Posts
    492
    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).

  3. #3
    Join Date
    Feb 2004
    Posts
    492
    or actually, if you choose to do a distinct insert, truncate the table with the doubles and inserrt from the new table back into the old one.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •