>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)
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges