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.

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


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 Vatsalya [MSFT] 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.

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.