9

I've recently generated scripts for a legacy database, and discovered that most of the tables were created with TEXTIMAGE_ON [PRIMARY], but there's only one filegroup.

TEXTIMAGE_ON [PRIMARY] is redundant when there is only a single filegroup, correct?

11

Yes, this is redundant. By default, SSMS will script these

The option is here:

SSMS File group option

|improve this answer|||||
2

This is a also a long standing bug because it also generates TEXTIMAGE_ON when running the script fails because that option is set when no appropriate text columns!

|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.