March 15, 2011 at 10:55 am
I created this table simply as a dummy table i can use to fill in a new database with generic data. I'm using SS2008. There are no restraints unless they are built in by default which i seriously doubt is the case.
Well anytime I place a duplicate row into the database (which is allowed it just a plan DB with no restraints) i get a crazy error. "Error Message: The row value(s) updated or deleted either do not make the row unique or they alter multiple rows (2 rows). Correct the errors and retry or press ESC to cancel the change(s)."
this happens when i want to manually delete or update one of the records in the EDIT window panel by going to EDIT TOP 200 ROWs. For example Column5 may be sequential. But since i copied the row and pasted into the bottom where the NULL row is, it is exactly duplicate. BUt i can't alter just ONE of the two rows. That makes no sense!!! I could understand a little better if this was the Select panel. it would not know which of the two i was changing but here i should allow me to pick the one i'm changing. I HAD NO PROBLEMS DOING THIS IN SS2005! I'm frustrated and confused.
March 15, 2011 at 11:01 am
You are getting the error because you do not have anything that makes the rows unique.
The way the rows are presented in SSMS are different than how they are stored internally, there has to be something that defines a row of data otherwise SQL Sever does not know which row to delete.
Best advice would be to add a primary key to the table, all tables should have a primary key by default.
March 15, 2011 at 11:05 am
The Edit rows feature is by no means anything you should be using to edit your data. The edit feature runs a transaction until you close it and when you delete or insert duplicates it has no way of identifying which row is being changed.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
March 15, 2011 at 12:20 pm
Thanks. Now i don't remember having this problem in the past with SS 2005. Any comment? Did it change? I could test it but i believe i've played with 2005 so many times i should know this.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply