• Great article/ series! Makes me want to start documenting my databases! 😛 (Yea, I'm way behind on that)

    Your first image depicting the sys.extended_properties view looks different from mine. I'm running SS2008R2, and my columns match your article description (ie major_id, minor_id, name, value), but your image has column names of PropertyType, SchemaName, TableName, etc). Was that the wrong image, or did you join the sys.extended_properties view to other system views?

    Thanks!

    patrick