Does not seem to support TEXT type columns

Sep 21, 2011 at 10:09 AM

Getting following error while running the utility with /C:ClearPartition and /A:ST_1_TBL1 (and other valid parameters):

Create failed for Table 'dbo.ST_1_TBL1'.
An exception occurred while executing a Transact-SQL statement or batch.
Invalid filegroup 'PART_SCH_ID' specified.

Using SQL profiler checked what's going on and could extract following query, generated by the utility, which is failing:

 [C_ID1] [numeric](19, 0) NOT NULL,
 [C_ID2] [numeric](19, 0) NOT NULL,
 [C_TEXT] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 [C_DATE] [datetime] NOT NULL CONSTRAINT [ST_1_TBL1_DF__TBL1__0BC6C43E]  DEFAULT (getutcdate()),
 [C_TIME] [timestamp] NOT NULL

Note the TEXTIMAGE_ON clause - instead of referring to the correct filegroup (PART_FG1) it is using PART_SCH_ID which is the name of the partition scheme and is not a filegroup

If I drop the ntext column from this table OR run this for any other table, not having text/ ntext type column, it works perfectly

Is this a  bug? Please helpl


Sep 23, 2011 at 11:30 AM

Faced the same issue with the other commands like /C:CreateStagingFull too

Nov 21, 2012 at 9:56 PM

This behavior is a bug in the current code and affects tables with all long types such as Text, Ntext, varchar(max), varbinary(max), etc.  I will be releasing a new version shortly with this fixed. 

Nov 29, 2012 at 3:47 AM

Fixed in version 3.0