Home Dashboard Directory Help
Search

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


Status: 

Closed
 as Fixed Help for as Fixed


1
0
Sign in
to vote
Type: Bug
ID: 682533
Opened: 8/1/2011 7:43:36 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

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.
Details
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.
Sign in to post a workaround.