Hi

Your Comment has error :

alter index [NonClusteredIndex-MydateFiled] on MyTable rebuild on MyParScheme([MyDateFiled])

And I Did this :

My Table had an cluster index on id.

I Remove it And Create New NonCluterIndex On MyDate Filed. (It Took me about 1 Hour and 30 min!!!)

CREATE NONCLUSTERED INDEX [NonClusteredIndex-MydateFiled] ON [dbo].[MyTable]

([MydateFiled] ASC)

WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)

GO

But After that I dont see any change in files and file Group.

--------

I was thinking about it and Found that in any Steps of my partitioning I didnt use this table name????

1- Create New FG

2- Create New Files And related them to FG

3- Create Patition Function

4- Create Scheme Function

And Where is my table and my field That I want to Partitioning on that ?