>>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)
Hi Hugo,
Very useful link; thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham