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 rebuildSELECT 'dbcc dbreindex(''xxx.DBO.' +name+ ''')' FROM sysobjects WHERE xtype='U'