Query to Rebuild Indexes on SQL Server 2000 Database

• vamshi.sql

  SSCommitted

  Points: 1770

  More actions

  April 20, 2011 at 8:29 pm

  #237025

  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.

• Orlando Colamatteo

  SSC Guru

  Points: 182279

  More actions

  April 20, 2011 at 9:34 pm

  #1314287

  Double post. Please reply here: http://www.sqlservercentral.com/Forums/Topic1096678-391-1.aspx

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato