Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
izaltsman
A custom title
1139 Posts |
 Posted - 2001-11-24 : 22:28:27
|
| Hi All!I have several large tables with a text fields in them. These tables were created, using TEXTIMAGE_ON [PRIMARY] option. Now I need to figure out a way to move text data out of PRIMARY into a separate filegroup. The problem is that ALTER TABLE statement does not seem to offer TEXTIMAGE_ON option like CREATE TABLE does. The only way I can accomplish this task at the moment, is to create tables with the same structure as my problem tables, but using TEXTIMAGE_ON [textfilegroup] option, copy the data over, drop original tables, and rename new tables to the original names. I am hoping I can avoid this ordeal, so if you know a good way of doing this, PLEASE let me know. |
|
|
|
|
|
Move text column to a different filegroup