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)
Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat. The purpose of this eBook is to educate the reader about ransomware attacks.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…