Tuesday, October 25, 2011

How to reindex all tables in a database

Let assume that the database is named clo
USE clo
GO
EXEC sp_MSforeachtable @command1="print '?' DBCC DBREINDEX ('?', ' ', 80)"
GO
EXEC sp_updatestats
GO

No comments:

Post a Comment