Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hong_ma
Starting Member
37 Posts |
 Posted - 2006-03-13 : 15:22:34
|
| when I wanted to delete a record from the database , I got a error message"key column information is insufficiant or incorrect, Too many rows were affected by update". waht's that mean? Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-03-13 : 15:24:11
|
| It means you don't have a primary key or unique constraint on your table and that you are trying to delete data without using DELETE comamnd. So are you using Enterprise Manager to do this?Tara Kizeraka tduggan |
 |
|
|
hong_ma
Starting Member
37 Posts |
Posted - 2006-03-13 : 15:30:41
|
| yes,no primary key or unique constraint on my table. I was using Enterprise manager to do this. because there are duplicate record in the database |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-03-13 : 15:34:57
|
| Well you need to either perform the delete in Query Analyzer using DELETE command or you'll need to add a primary key or unique constraint.Tara Kizeraka tduggan |
|
|
|
hong_ma
Starting Member
37 Posts |
Posted - 2006-03-13 : 15:39:56
|
| got it, Thanks. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-03-14 : 02:07:11
|
| Never do DMLs using EM. Use Query Analyser onlyMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
problem to delete a record from SQL 2K