dwain.c (9/26/2013)
I love extended properties. Very comprehensive introductory article!The only think I find annoying about them (unless I missed something) is that you can't update them. Need to delete then add.
A problem with 2008R2 is that the stored procedures can leave an open transaction when there is a failure in adding a property.
https://connect.microsoft.com/SQLServer/feedback/details/658556/sp. While easy enough to work around once you know about the possibility, it took me quite a while to figure it out.