InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 01:28:04 GMT20http://www.sqlservercentral.com/Forums/Topic1096678-65-1.aspxI found this useful bit of code :Run the following script changing the xxx for the database name, run against master.SELECT 'dbcc dbreindex(''xxxxxxx.DBO.' +name+ ''')' FROM sysobjects WHERE xtype='U' This will generate a rebuild statement for each index, copy the output from the results window and paste it to the QueryAnalyzer window and run against the right database. This can obviously be repeated for each database as required.Wed, 31 Oct 2012 09:50:56 GMTPete.murrayhttp://www.sqlservercentral.com/Forums/Topic1096678-65-1.aspx[quote][b]vamshi.sql (4/20/2011)[/b][hr]Hi,Can anyone please let me know the query to rebuild all the indexes in an SQL Server 2000 Database??I need to rebuild all the indexes in database at a time using single query.Thanks in advance,Vamshi.[/quote]Vamshi,You can get the script here.[url=http://www.sqlserverblogforum.com/2011/03/index-defragmentation-script-for-sql-server-2000/][u] SQL server 2000 Index rebuild script[b][/b][/u][/url]Thu, 21 Apr 2011 06:17:36 GMTmuthukkumaran Kaliyamoorthyhttp://www.sqlservercentral.com/Forums/Topic1096678-65-1.aspxNo need to post yet again. I've asked the mod to move the thread.Wed, 20 Apr 2011 23:34:40 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1096678-65-1.aspxYou posted in a SQL 2008 forum. Not that you won't receive help, but you may have better luck posting your question in one of the SQL 2000 forums. [url=http://www.sqlservercentral.com/Forums/Group406.aspx]http://www.sqlservercentral.com/Forums/Group406.aspx[/url]Wed, 20 Apr 2011 21:36:14 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1096678-65-1.aspxHi,Can anyone please let me know the query to rebuild all the indexes in an SQL Server 2000 Database??I need to rebuild all the indexes in database at a time using single query.Thanks in advance,Vamshi.Wed, 20 Apr 2011 16:26:11 GMTvamshi.sql