I was just giving someone a walk-thru of the SQLSpec output and she asked "What happens when we do a drop/create on an object?" Since the extended propertied are stored by object ID, not name, the properties get deleted when the object is dropped (I just confirmed that they are deleted, not orphaned).
Has anyone come up with an elegant solution to this? I can imaging pulling out the extended properties before the drop and re-adding them after the create.
quick update: I just created a new release of scriptdb on codeplex that supports scripting of extended properties. to use it, pass -p to specify you want the extended properties scripted. here's a sample command line: