Avoiding row deletion with a trigger

• João Miguel Domingos

  SSC Enthusiast

  Points: 114

  More actions

  December 24, 2004 at 4:25 am

  #162095

  Hi everybody,

  I'm moving from Borland Interbase and I'm a newby in SQL Server.

  I have a table with a column that hold the user name of the user that inserted the row. I need to implement a function that, when someone tries to delete one row in the table, verifies if the user who want to delete is the same that created the row. If not I need to cancel the action.

  Do you think this can be done with a INSTEAD OF trigger ? If not what technique do you recomend ?

  Thank you in advance

  Best regards

  João Miguel

• Dave-3000

  SSCertifiable

  Points: 6186

  More actions

  December 27, 2004 at 11:28 am

  #535073

  An INSTEAD OF trigger should work.  Check out "Designing INSTEAD OF Triggers" in BOL.

  There is no "i" in team, but idiot has two.

• João Miguel Domingos

  SSC Enthusiast

  Points: 114

  More actions

  December 28, 2004 at 12:59 pm

  #535183

  Thank you Dave,

  I will read the BOL section to try to do it.

  Best regards

  João Miguel