Translate

Friday, August 5, 2011

How to Reindex all the tables in a database

Run this query in the SQL database where you want to re index all the tables

exec sp_MSforeachtable @command1="DBCC DBREINDEX ('?')"
Posted by Vivek

No comments:

Post a Comment

Comments will appear once they have been approved by the moderator

Subscribe to: Post Comments (Atom)