Auto Stats Not Working Sql 2005

The auto stats not working

I have both Auto Update Statistics and Auto Update Statistics Asynchronously set to True




USE [TEST]

GO

/****** Object: Table [dbo].[CUSTOMER] Script Date: 12/29/2007 10:42:49 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[CUSTOMER](

[Customer_Id] [nchar](10) NOT NULL,

[Customer_Name] [nvarchar](1000) NULL,

[Customer_Address] [nvarchar](1000) NULL,

[Customer_Address1] [nchar](1000) NULL,

CONSTRAINT [PK_CUSTOMER] PRIMARY KEY CLUSTERED

(

[Customer_Id] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]

) ON [PRIMARY]




--Created an insert table
DECLARE @COUNT INT

SET @COUNT = 1

WHILE @COUNT <= 1000

begin

insert into CUSTOMER (CUSTOMER_ID, CUSTOMER_NAME)

VALUES (@COUNT, '12345678901234567890')

SET @COUNT = @COUNT + 1

END

Look at Tables then statistics the statistics are empty so i fire update statistics and see 1000 rows in here.

I run again the insert script
DECLARE @COUNT INT

SET @COUNT = 1001

WHILE @COUNT <= 2000

begin

insert into CUSTOMER (CUSTOMER_ID, CUSTOMER_NAME)

VALUES (@COUNT, '12345678901234567890')

SET @COUNT = @COUNT + 1

END


Look again at statistics it not firing.

If i do select * from CUSTOMER where CUSTOMER_ID = '2000' then go checks statictics it works.

I was under the impression that when you do insert or delete, update then the statistics are fired.

The sys.sysindexes rowmodctr shows the 1000 rows.

I checked the conditions that sql fires if the no of rows int able > 6 and < 500 then updates when 500 mods made.
Also if row > 500 auto update done when 500 = 20% are added

So both are met.

Anyone other any other suggestions about the auto stats ?