scripting a table and selecting Extended Properties generates two lines for each MS_Description field property

I’ve added field description to the table with MS_Description extended property. This appears fine in TDP’s navigation manager. When I go to the script tab and check the Extended Properties checkbox, I get each field’s MS_Description property line twice. The second sp_addextendedproperty line generates an error when the script runs; the property already exists at that point.

I’m running TDP against SQL Server 2008r2.

I verified this behavior and created a bug fix task for it: QAT-3766

This also occurs in the “Create Like Table” generation script. I’m assuming it is the same code behind this.


This issue has been fixed. Please try in next version.

Best Regards,