I'd rather not drop and recreate the table. CREATE TABLE lets you specify where TEXT columns will be stored, but ALTER TABLE doesn't seem to have a clause in it that allows you to change it.
I've done due diligence in looking for a sol'n in BOL and other forums.
Here's the table
CREATE TABLE [tbEmailMessage] (
[EmailMessageID] [int] IDENTITY (1, 1) NOT NULL ,
[SendDate] [dtDatetime] NOT NULL ,
[SendTime] [dtDatetime] NOT NULL ,
[SenderName] [dtString] NOT NULL ,
[SenderEmail] [dtString] NOT NULL ,
[Message] [text] COLLATE Latin1_General_BIN NULL ,
[RawMessage] [text] COLLATE Latin1_General_BIN NULL ,
[Timestamp] [timestamp] NOT NULL ,
PRIMARY KEY CLUSTERED
(
[EmailMessageID]
) WITH FILLFACTOR = 90 ON [EMAIL_DATA]
) ON [EMAIL_DATA] TEXTIMAGE_ON [PRIMARY]
GO
When I recreated the PK, for this table (WITH DROP_EXISTING) to have the data reside on the new filegroup (EMAIL_DATA), I thought it would bring all the text column information with it, but as you can see, it didn't.
Can anyone shed light?
THANKS,
Greg