s**m 发帖数: 1564 | 1 This is about extended property.
Here is background: when a table/column is created/altered/dropped, extended
properties are inserted/updated/deleted. also table's/column's extended
property can be updated later (not via alter table/column syntax) using
below system procedures (or raw insert/update/delete scripts):
sp_addextendedproperty
sp_updateextendedproperty
sp_dropextendedproperty
Here is my goal: now when an extended property is created/updated/dropped, I
want to fire a trigger which will update a table in another database.
extended property is stored in system base table sys.sysxprops
can trigger be defined on this table?
also extended property can be queried via catalog view sys.extended_
properties
can trigger be defined on this view?
which is better?
please point me to some resources.
Thanks. |
|