# scripting a table and selecting Extended Properties generates two lines for each MS\_Description field property

**URL:** <https://forums.toadworld.com/t/scripting-a-table-and-selecting-extended-properties-generates-two-lines-for-each-ms-description-field-property/30740>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [August 21, 2014, 3:25pm UTC](https://forums.toadworld.com/t/scripting-a-table-and-selecting-extended-properties-generates-two-lines-for-each-ms-description-field-property/30740 "2014-08-21T15:25:44Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![sking](https://avatars.discourse-cdn.com/v4/letter/s/8c91f0/32.png) [@sking](https://forums.toadworld.com/u/sking)\
**Post date:** [August 21, 2014, 3:25pm UTC](https://forums.toadworld.com/t/scripting-a-table-and-selecting-extended-properties-generates-two-lines-for-each-ms-description-field-property/30740/1 "2014-08-21T15:25:44Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![RyanJohnson](https://avatars.discourse-cdn.com/v4/letter/r/f04885/32.png) [@RyanJohnson](https://forums.toadworld.com/u/RyanJohnson)\
**Post date:** [August 21, 2014, 4:42pm UTC](https://forums.toadworld.com/t/scripting-a-table-and-selecting-extended-properties-generates-two-lines-for-each-ms-description-field-property/30740/2 "2014-08-21T16:42:24Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![sking](https://avatars.discourse-cdn.com/v4/letter/s/8c91f0/32.png) [@sking](https://forums.toadworld.com/u/sking)\
**Post date:** [August 28, 2014, 11:55am UTC](https://forums.toadworld.com/t/scripting-a-table-and-selecting-extended-properties-generates-two-lines-for-each-ms-description-field-property/30740/3 "2014-08-28T11:55:02Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Kelly.Chen](https://avatars.discourse-cdn.com/v4/letter/k/dfb087/32.png) [@Kelly.Chen](https://forums.toadworld.com/u/Kelly.Chen)\
**Post date:** [January 6, 2015, 9:49pm UTC](https://forums.toadworld.com/t/scripting-a-table-and-selecting-extended-properties-generates-two-lines-for-each-ms-description-field-property/30740/4 "2015-01-06T21:49:33Z")

</div>

Hi,

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

Best Regards,

Kelly