log in

Changing a table's TEXTIMAGE filegroup in SSMS

2008-02-07 20:03 UTC

To modify a table's TEXTIMAGE_ON property in SQL Server Management Studio 2005, right click on the table and click Design. Press F4 to bring up the Properties window. Change the Text/Image Filegroup property and click the Save icon in the toolbar.

Note that changing this property causes SSMS to rebuild the table and all table relationships. This is a slow operation. It can take a minute or two depending on the speed of your server and size of the table.

I'm making a note of this because it took me longer than I'm willing to admit to find this window. The other table properties window (right click on the table and click Properties) is a read-only display of table information. In SQL 2000, this was editable.