0

I have run a query through pane in sql server 2008. Now I want to change some data from the result, but it shows error, "No row was updated. The data in row 2 was not committed".

How can I change data in pane result.

chue x
  • 18,573
  • 7
  • 56
  • 70
Gaurav
  • 557
  • 4
  • 11
  • 28
  • 1
    sounds like you can't change the date because it would violate a unique index or primary key. Otherwise the updates would work though the pannel... – xQbert May 27 '13 at 03:02
  • then what is the solution? – Gaurav May 27 '13 at 03:03
  • 1
    Well, confirm that is its a unique index/ primary key violation. and if it is adjust your data so that you're no longer violating a unique index or key, or drop the index/key. (but be careful about dropping those!) – xQbert May 27 '13 at 03:06

0 Answers0