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)
Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed.
Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…