Saturday, February 25, 2012

Change the "text filegroup" property of an existing table

How can I change the property "text filegroup" of an existing Table?

Thanks
Markus

In enterprise manager, right click the table and choose "design table", then click the "table and index properties" icon (2nd from left, next to save) and then set the Text Filegroup option as appropriate.|||I'm using SQL Server 2005|||right click on the table and select properties. you have the option to change it there.|||at the properties tab, General, everything is write protected (SQL Server Management Studio)|||TextFilegroup is set at the creation of the table via the TextImage_On {fg}. In sql2k, when you modify the TextFilegroup property, the system actually:
1. create a new table with textimage_on
2. insert into the new table with the old table data
3. drop the old table
4. rename the new table to old

The above functionality still exists and works the same in sql2k5. Right click on the table; select "modify"; press F4 to bring up the properties pane; change the TextFilegroup as desired.

No comments:

Post a Comment