Home Forums SQL Server 2014 Development - SQL Server 2014 updates are not happening through ssms RE: updates are not happening through ssms

  • March 3, 2018 at 8:13 am

    #1981846

    dastagiri16 - Saturday, March 3, 2018 6:40 AM

    Phil Parkin - Saturday, March 3, 2018 6:26 AM

    dastagiri16 - Saturday, March 3, 2018 6:22 AM

    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.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)