Dear Nigel

I've put your code into admin database.

Can i run your code every month ?

Dear

Huil0n6

Dear Tom

Can you tell me more detail about sp_msforeachtable and sp_msforeachdb, and how to use that.

Because i'm a newest in SQL Server.

Best Regards

Huil0n6

It's solve my problem.

Thank's for who has help me.

Best Regards

Huil0n6

Dear Brian

I mean, can i reindex for all table in one database with one syntax ?

If i use dbcc dbreindex(table name),

i must be looping for each table in database.

Best Regards

Huil0n6

...

Thank's Paul and Nigelrivett.

Now i got new problem such as

in one table i use more than one index maybe 2 or 3. So if i want to delete data...

Dear Paul

I've try your idea.

It's work, size of index is change to smaller.

I run dbcc dbreindex without fillfactor,

What different if i use fillfactor or not ??

Thx

Huil0n6