March 27, 2009

Reindex whole database

EXEC sp_MSforeachtable @command1="print '?' DBCC DBREINDEX ('?', ' ', 80)"
GO
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)