>>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)

See this one
http://sqlfool.com/2010/04/index-defrag-script-v4-0/

and (http://serverfault.com/questions/80307/best-way-to-rebuild-all-indexes-on-all-tables-in-sql-server-2005/80352)

http://ola.hallengren.com/