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 |
|
mrtweaver
Yak Posting Veteran
67 Posts |
 Posted - 2009-02-26 : 16:12:09
|
| I have a table it has 29 rows in it with 8 columns per row. WHile I was trying something I made several of these rows have the exact same data in them. Now when I go in and try to delete the duplicate rows of data I get the following error message:A problem occured while attempting to delete. The row value(s) updated or deleted do not make the row unique or they alter multiple row(s)I have tried to manually go in and change the data to make the rows unique, have also tried to delete all the records that were the same but still get the error message.So can someone please tell me how to delete these records?Thanks and have a great day. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Deleting data from table