hi,
I have created after insert ,update,delete trigger for one of the table.The table does not have any primary key.When we are trying to update the table in edit top 200 rows ..it is preventing to update the records..when i drop the trigger it is allowing..is the anything i missed?
Probably.
Hi ,
Thanks for u r reply..
I alredy searched a lot and did not find anything about the issue.
Its straight question ..if we add trigger for a table will it prevent editing the table from edit 200 row option. When we perform delete ,update ,insert through query..it is working as expected..the only problem here is with gui option.
Correct. It's a very straight question with a very straight answer (which Phil actually provided). Since everything works correctly after you drop the triggers, it's obviously the triggers that are the problem. They key is that the SOLUTION is not so straight forward but there's no way for us to help until you post the code to create the table, all the related indexes and constraints, AND the code for the triggers.
Hi Jeff,
is trigger blocking my table updation from gui .is it expected behavior of triggers ? the trigger code is having problem how the updates are happening from update query? That is what my concern.
I will share my table script and trigger script tomorrow.