How Can I Re Index All tables in One Go? 1

[u104741]

Sorry if the ansers is on here.. I have looked!!

I want a SQL Sript that i can run in Query Analysier that will re-index all my existing indexs in all tables in a database.. i am aware of the dbreindex command but is there one I can use that I dont have to specifiy each table??

Hope that makes sense...

Cheers,
JJ.

 

[vongrunt]

You can try:

sp_msforeachtable 'dbcc dbreindex(''?'')'

... but be careful. It may take long time to finish.

------
Math problems? Call 0800-[(10x)(13i)^2]-[sin(xy)/2.362x]

 

[u104741]

nice one just the job.

Many thanks.
JJ