I have a problem with SQL Server Management studio 2005 and later versions.
I get an error if I manually change the value of a column in a record of a specific table.
The table in question has a trigger which affects more than one row in a different table and it would appear that SQL Server Management Studio cannot cope with this ?
If I change the table data with an update query then no error is generated and the records in the other table are changed by the trigger with no problem.
The changes in the other table do not affect each recor'd uniqueness so I guess that the problem is due to the changing of more than one record ?
The trigger is invoked after UPDATE,INSERT
The error message that I get is as follows:-
Error Source : Microsoft VisualStudio.Data tools
The row value(s) updated or deleted either do not make the row unique or they alter multiple rows(5 rows)
Is there a fix for this ?