Rebuild indexes SQL Server 2000

Lets say you want to rebuild indexes for a particular table in SQL Server 2000. Then you can generate the script to rebuild the indexes using the below command in Query Analyzer. Where xxx is the name of the database who indexes you want to rebuild

SELECT ‘dbcc dbreindex(”xxx.DBO.’ +name+ ”’)’ 
FROM sysobjects WHERE xtype=’U’ 

Advertisements