Rebuild all Indexes in SQL SERVER
SQL Server 2000 Rebuild all indexes with keeping the default fill factor for each index USE [DATABASE_NAME] EXEC sp_MSforeachtable @command1=”print ‘?’ DBCC DBREINDEX (‘?’)” Rebuild all indexes with specifying the…
K-Smart, IT Business Solutions
Find ideas to implement your IT enviroment
SQL Server 2000 Rebuild all indexes with keeping the default fill factor for each index USE [DATABASE_NAME] EXEC sp_MSforeachtable @command1=”print ‘?’ DBCC DBREINDEX (‘?’)” Rebuild all indexes with specifying the…