Hello,I want to partition a table but am having problems with the partition creation ALTER DATABASE Temp_DJJ ADD FILEGROUP MyTestFG;GOALTER DATABASE Temp_DJJ ADD FILE ( name = Test_ReadOnly1, filename = 'C:\SQLData\MyTestFG.ndf', size = 10mb, maxsize = 200mb, filegrowth = 5mb) TO FILEGROUP MyTestFG;GO-- 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');GOCREATE PARTITION SCHEME TestIt AS PARTITION TestPF TO ([PRIMARY], MyTestFG);GO
On 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? Thanks