I am trying to delete a row in sql server management studio 2012 but an error appears:
No rows were deleted
A problem occurred attempting to delete row 2 Error Source: Microsoft.SqlServer.Management.DataTools Error Message: The row value(s) updated or deleted either do not make the row unique or they alter multiple rows(2 rows)
Is there a way to fix error that without typing any query?
You don't have a primary, unique key in your table.
SQL Server is unable to delete your row because nothing discriminate it from the other rows.
The solution is to add a unique Primary key to your table. It is not recommended to have none anyway. A simple integer with autoincrement should work transparently for you.
