May 2, 2007 at 2:54 am
Hi All
Iam working with SQL 2005 and have created a testtable, where values are stored these values come from a stored procedure, using an insert in command into the testtable.
However when I go and try to delete the data in the testtable I get the following error message :-
Error Source: Microsoft.VisualStudio.DataTools.
Error Message: The row value(s) updated or deleted either do not make the row unique or they alter multiple rows.
Anyone knows what this means?
Many Thanks
May 2, 2007 at 9:35 am
Since we don't know what your schema/data looks like and what you did, it's difficult to tell what the error means.
My guess....you have a Primary Key or Unique Key set up on one or more columns. The data you are deleting will cause the uniqueness to no longer exist.
-SQLBill
July 10, 2007 at 4:24 am
Could you post the query and the metadata being used.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply