TEXTIMAGE_ON Missing When Scripting Tables with SSMS 2005 & 2008R2 - by HLogic

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


1
0
Sign in
to vote
ID 682533 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 8/1/2011 7:43:36 AM
Access Restriction Public

Description

I am not sure which SP or if both (SQL2005 SP4 or SQL2008R2 SP1) caused the omission but...

SSMS 2005 Version 9.00.5000.00
SSMS 2008R2 Version 10.50.2500.0

Neither is scripting the TEXTIMAGE_ON clause.  In my situation, the table is created on a data filegroup other than primary and the LOB data is on a separate filegroup.

This is the same issue as described in:  http://connect.microsoft.com/SQLServer/feedback/details/640618/textimage-on-is-lost-when-scripting-table-using-ssms and other feedback.
Sign in to post a comment.
Posted by Microsoft on 6/7/2012 at 2:38 PM
Hi HLogic,

This issue has been fixed, and has been verified internally. This should be available in the next available public release of SQL Server.

Thanks for writing in to Microsoft.

-Vatsalya
Posted by HLogic on 8/1/2011 at 7:50 AM
As an addendum, this functionality worked in both SSMS 2005 SP3 and SSMS 2008R2 RTM.