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:
CREATE TABLE [dbo].[ST_1_TBL1](
[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
) ON [PART_FG1] TEXTIMAGE_ON [PART_SCH_ID]
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