I'm uncomfortable with this solution. It seems to be a bit too esoteric/arcane for my tastes. My solution is to have a couple of small tables that handle the information and then a front end on the company intranet to handle data entry, updating status, sending email, etc.

It seems to me that extended properties are too hidden and too easily lost to make for a good repository for this data. Even if you have documented how and why and where, the next person in your position has to find that documentation and unravel it. If you put this data in a database that is visible from the console it becomes very easy for the next person to find.

Also, extended properties seem quite limited as you show by having to store a list instead of scalar values. You wouldn't want to do this with data under normal circumstances, so why now?

--

JimFive