Post reply

Error in updating the value of a fiel (whic executes trigger)

  • December 31, 2008 at 5:41 am

    #199554

    Dear All,

    I have written a trigger in one table, which updates a dummy table on the updation of one particular field. No relation or any other constriants in that table.

    But when I update the value am getting the following error.

    "The data in row 1 was not commited.

    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(2 rows)"

    There one and only one record in the dummy table which it updates the value. Dont know why am I getting this error..

    Pls help..

    Thanks in advance.

    M.V Santhosh Nair.

  • January 3, 2009 at 12:06 am

    #920649

    Dear All,

    I got the solution from microsoft website. Actualy it's a bug in SQL Server 2005 itself.This error won't occur if we update the value by executing query in query window.

    I solved this issue by just adding one Primary Key field in the table.

    Thank you all.

    Santhu.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply