>>sp_MSForEachTable :-)
>>
>>EXEC YourDBName..sp_MSforeachtable 'DBCC DBREINDEX(''?'')'
>>
>
>
>I think a better idea is to reindex just the tables that need to be reindexed, what do you think?
>
>
http://blogs.msdn.com/b/boduff/archive/2007/06/08/smart-indexing-part-ii-conditional-rebuilding.aspx>
>(the code there have some flaws for it is not always using the [] so it can create problems, but I found the idea pretty neat)
Yes, smart indexing is the best approach,
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.