I have an sql server 2005 database table.
the first column is a uniqueidentifier but there is no primary key.
I did a copy paste on a row thinking it would paste everything ACCEPT the uniqueidentifier coumn.
However, it copied everything... so now I have an exact dup record.
I cannot delete the dup.
I get the "The row value(s) updated or deleted either do not make the row unique..." msg
I tried to add a field and give it a separate value for the two records... but it will not let me edit the record to add data to the new column (same msg as above).
The following causes sql to crash
set rowcount 1
delete from mytable
where mycolumn = 'myvalue'