Seems like you would just go through one table at a time like this:
dbcc dbreindex ("table1")
go
dbcc dbreindex ("table2")
go
dbcc dbreindex ("table3")
go
etc...
- BILL -
----- Original Message -----
From: "ikke ikke" <[Email Address Removed] <[Email Address Removed] Thursday, August 15, 2002 10:58 AM
Subject: Index...
>
> I want to reindex all my indexes in all my tables
>
> How i can do that
>
> Thank
>
>
> _________________________________________________________________
> Affichez, modifiez et partagez gratuitement vos photos en ligne:
> http://photos.msn.com/support/worldwide.aspx
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed]
>
MS Sql Server LazyDBA home page