Toad World® Forums

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


#1

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 3.5.0.2926 against SQL Server 2008r2.


#2

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


#3

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


#4

Hi,

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

Best Regards,

Kelly