Is there a way to associate a description with database snapshot?
I usually name snapshots using original database name and timestamp:
I would like to be able to associate a comment like "Before executing schema update scripts related to feature NNN" with a snapshot.
This is something that I could put in database extended properties but since snapshot is read-only it is not possible after it is created and it doesn't look like extended properties can be specified as a part of snapshot creation. Making these comments a part of snapshot name is ugly.
Is there any other way to associate a metadata with database snapshot when it is created? Of course I can maintain a table in separate utility database just for this but this is not too convenient.