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 6:40 am

    #1981840

    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.