sql-servertriggersextended-properties

Trigger on extended properties? SQL SERVER


Does SQL Server allow triggers on extended properties, table level or column level?

If not, is there anything like a trigger that can detect an 'add' or 'update' on extended properties and execute a stored procedure automatically?

Thank you!


Solution

  • You can use a DDL trigger for this.

    CREATE TRIGGER foo
    ON DATABASE
    FOR CREATE_EXTENDED_PROPERTY, ALTER_EXTENDED_PROPERTY
    AS
      BEGIN
          /*TODO: Something useful here*/
          SELECT EVENTDATA()
      END