Home Forums Article Discussions Article Discussions by Author Discuss content posted by Adam Aspin Extended Properties Introduction RE: Extended Properties Introduction

  • March 17, 2011 at 1:27 pm

    #1300189

    Alexander Kuznetsov (3/17/2011)

    Hi Adam,

    The following sounds like a good reason: "tracks object evolution automatically".

    Thanks for the answer.

    AK

    The only problem (re: object evolution) I've found is in SQL Server 2005 on user-defined functions, the ALTER FUNCTION statement would cause extended properties to be lost. I think this was fixed in 2008. This is not a problem with ALTER PROCEDURE.

    Renaming objects or changing schemas seemed to work fine in SQL Server 2005.