To many rows effected..

[Blimey]

Got a duped item in DB, wna remove it but i keep getting error saying to many rows effected. I tried google but none of it makes any sense lol. Help plz!

 

[T0MMY]

* Delete one at once.
* Check your item ID if same, change it.

 

[Blimey]

cant delete it, theres only 2 rows left. And they both the exact same. Also cant rename/edit any part of it =/

 

[DevilWish]

if its sql i think you can put the sql into emergency mode then u can edit the dup failing that is to rebuild a fresh table using from before dup row and after it hope that helps

 

[FTM21]

get microsoft office and use access export stditem db delete the duped item then import bk into sql job done

 

[Blimey]

How do i run in emergency mode plz ?

 

[DevilWish]

9.Switch to emergency mode on the database. You do this by doing the
following:



1.Right click on the database root node in Enterprise manager and
bring up the properties.
2.Under the Server Settings tab, check of "Allow modifications
to be made directly to the system catalogs".
3.click ok
4.Now go to the master database and open the sysdatabases
table.
5.Find the suspected database in here and modify the status column,
setting it to: 32768. This will put it into emergency mode.
6.stop then start sql server


hope this helps

 

[Gezza]

you could always try this http://www.lomcn.co.uk/forum/showthread.php?67270-SQL-DUP-Remover