How to created Extended Properties for all Fields in DB

  • In the last days we need to create some Kind of Extended Property equal to MS_Description, that where avaliable when a table where created and also when a field into this table where created.

    This property should to be avaliable for all Fields from All Tables into the Database.

    We Create a Tigger Database that Check the ALTER_TABLE and TABLE_CREATE and Procedes to the Creation of this Extended Property when the Table is Modified or Created.

    Somebody know other better Method ?

    Thanks ....

  • have a look at sp_addextendedproperty !


    * Noel

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply