Sql Error

[LadyBliss]

I was adding some new mobs into sql and accidently got a duplicate, now sql is giving me an error saying too may rows have been affected by change. Last time it happened I had to go to my last saved db and I really dont wanna do that again.

Please tell me theres some other way of fixing it besides causeing a major rewind?

:helpme: :helpme: :helpme:

 

[Kanj]

lol this happened to me too: - this is how I got round it

use the sql query analyser to run a query to return all rows with the same name eg select * from monster where name = "omawarrior"

copy and paste the results into Exel - and while you are there, delete one of the rows

ok - return to sql query analyser - new query

delete from monster where name="omawarrior"

that will get rid of the duplicates;

then in sql enterprise manager, right click on monster table, select all tasks, import data - and import the exel spreadsheet using DTS import wizard

Hope this is clear - if not , leave me a pm with your msn address and I'll try to do better

 

[Kanj]

lol this happened to me too: - this is how I got round it

use the sql query analyser to run a query to return all rows with the same name eg select * from monster where name = "omawarrior"

copy and paste the results into Exel - and while you are there, delete one of the rows

ok - return to sql query analyser - new query

delete from monster where name="omawarrior"

that will get rid of the duplicates;

then in sql enterprise manager, right click on monster table, select all tasks, import data - and import the exel spreadsheet using DTS import wizard

Hope this is clear - if not , leave me a pm with your msn address and I'll try to do better

 

[LadyBliss]

got it sorted thanks