Error Record Deletion Error

[DonP]

I have a table with lots of bad data that I wish to delete manually, directly in SQL Server Enterprise Manager, yet I cannot do so. All I get is an error: "Key column information is insufficient of incorrect. Too many rows were affected by update." I get this message whether trying to delete one or many rows. There is no Key column as far as I can tell, nor is autonumbering active on any of them yet. Any help would be appreciated. Thanks! Don
don@pc-homepage.com

http://www.pc-homepage.com/

Experienced in HTML, Perl, VBScript, PWS, IIS and Apache. Run OS/2 Warp 4, BeOS v5 and Windows NT (only when I have to!)

 

[grahamm]

This is a known problem with the Enterprise manager. See
artcle Q268505 at MS support

http://support.microsoft.com/support/kb/articles/Q268/5/05.ASP

The workaround is to use a delete stmt in the query analyzer e.g

delete from foo where ...

 

[DonP]

Thanks! Deleting the complete contents of the table is what I ended up doing, which was fine (I was going to do it eventually anyway), though I had not meant to do that just yet. Never the less, it solved the problem. Don
don@pc-homepage.com

http://www.pc-homepage.com/

Experienced in HTML, Perl, VBScript, PWS, IIS and Apache. Run OS/2 Warp 4, BeOS v5 and Windows NT (only when I have to!)