data are not allocated in the properly NDF. Why?

Hi everyone,

The followings actions works fine. But only the first NDF (PRIMERO) is growing up.

I don't get the point at all, I though that SEGUNDO would store February, TERCERO March and

CUARTO April to December (according RANGE LEFT)

I feel that there is something very important that I did not in all of this...

I'm stuck.

--Definition table

CREATE TABLE [dbo].[DatosMensuales](

[Id] [int] NOT NULL,

[Concepto] [varchar](50) COLLATE Modern_Spanish_CI_AS NULL,

[FechaAlta] [datetime] NULL

) ON rangoMesFE(FechaAlta)

CREATE PARTITION FUNCTION rangoMesFP(datetime)

AS RANGE LEFT FOR VALUES('200601','200602','200603');

CREATE PARTITION SCHEME rangoMesFE

AS PARTITION rangoMesFP

TO (PRIMERO,SEGUNDO,TERCERO,CUARTO);

--loading data properly

EXEC CARGARMESES '2006-01-01 00:01:01', 'PRUEBAS ENERO', 1, 10000

EXEC CARGARMESES '2006-02-01 00:01:01', 'PRUEBAS FEBRERO', 10001,20000

EXEC CARGARMESES '2006-03-01 00:01:01', 'PRUEBAS MARZO', 20001,30000

EXEC CARGARMESES '2006-04-01 00:01:01', 'PRUEBAS ABRIL', 30001,40000

SELECT $partition.rangoMesFP('200606') --> DATA IN THE FOURTH PARTITION, OK

Does anyone have any idea about this?

When I launch sp_helpdb only NDF which belong to PRIMERO partition are altered:

pruebas 1 C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\pruebas.mdf PRIMARY 7168 KB Unlimited 1024 KB data only
pruebas_log 2 C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\pruebas_log.ldf NULL 1024 KB 2147483648 KB 10% log only
fich_1 3 C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\fich_1.ndf PRIMERO 4096 KB Unlimited 1024 KB data only
fich_2 4 C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\fich_2.ndf PRIMERO 4096 KB Unlimited 1024 KB data only
fich_5 5 C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\fich_5.ndf CUARTO 3072 KB Unlimited 1024 KB data only
fich_6 6 C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\fich_6.ndf QUINTO 3072 KB Unlimited 1024 KB data only
fich_3 7 C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\fich_3.ndf SEGUNDO 3072 KB Unlimited 1024 KB data only
fich_4 8 C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\fich_4.ndf TERCERO 3072 KB Unlimited 1024 KB data only

|||This issue is already solved.