I want to partition a table but am having problems with the partition creation
ALTER DATABASE Temp_DJJ ADD FILEGROUP MyTestFG;
ALTER DATABASE Temp_DJJ ADD FILE (
name = Test_ReadOnly1,
filename = 'C:\SQLData\MyTestFG.ndf',
size = 10mb,
maxsize = 200mb,
filegrowth = 5mb) TO FILEGROUP MyTestFG;
-- Try for two partitions on prior to 6/1/12 and one after that.
CREATE PARTITION FUNCTION TestPF (DATETIME) AS RANGE LEFT FOR VALUES ('6/1/2012');
CREATE PARTITION SCHEME TestIt AS PARTITION TestPF TO ([PRIMARY], MyTestFG);
GOOn the CREATE PARTITION SCHEME I get the error:
Msg 208, Level 16, State 58, Line 1
Invalid object name 'MyTestFG'.
Not to mention I am unclear how to associate the table.
So where did I go wrong?