SQL field comments get messed up after DDL import

[DaveO]

When I reverse my SQL 2000 table back into my EA diagram (with selecting the "Synchronize Table Comments" option) it messes up all the comments for the fields (attributes).  I'm not sure what it's doing, but it copies some comments over others, shuffles some, and leaves some untouched.

E.g.
Before synch:
Field 1:  Comment 1
Field 2:  Comment 2
Field 3:  Comment 3
Field 4:  Comment 4
Field 5:  Comment 5
Field 6:  Comment 6

After synch:
Field 1:  Comment 1
Field 2:  Comment 2
Field 3:  Comment 2
Field 4:  Comment 5
Field 5:  Comment 3
Field 6:  Comment 6

It's really weird, and I've reproduced it a few times now.

I know that when I generate the DDL it uses the wrong Name for the sp_addextendedproperty call (it uses 'remarks' when it should be using 'ms_description'), but even if I don't fix this it still messes up my comments in EA after the import.  Very odd

[hd]

Thanks for pointing that out - we will investigate ASAP.