FAQ : How to run DBCC DBREINDEX against all the user table in SQL Server
Simple, use undocumented stored procedure sp_msforeachtable. Since its undocumented there is no gurantee that it will be available in all the future versions. But in SQL Server 2000 and 2005 it works.
Use YourdatabaseName
EXEC sp_msforeachtable 'DBCC DBREINDEX( ''?'')'
Use YourdatabaseName
EXEC sp_msforeachtable 'DBCC DBREINDEX( ''?'')'
posted by Madhu K Nair at
2:52 AM
0 Comments:
Post a Comment
Subscribe to Post Comments [Atom]
<< Home