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 |
|
venkath
Posting Yak Master
202 Posts |
 Posted - 2007-12-15 : 12:17:25
|
| Hi AllI have a table with NTEXT column.I would like to seperate NTEXT column and its Table into two seperate file groups.Is it possible to achieve this with out dropping and recreating the table?Thanks in advance. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-12-15 : 16:51:01
|
Yes. Create a new table on the bew filegroup with PkCol and NTEXT col.Then INSERT NewTableSELECT PkCol, NTEXTcolFROM SourceTable
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
|
|
|
Seperating NTEXT column and its table