Home Forums SQL Server 7,2000 Performance Tuning Query to Rebuild Indexes on SQL Server 2000 Database RE: Query to Rebuild Indexes on SQL Server 2000 Database

  • April 21, 2011 at 6:17 am

    #1314450

    vamshi.sql (4/20/2011)

    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.

    Vamshi,

    You can get the script here.

    SQL server 2000 Index rebuild script[/url]

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/