rebuild index using enterprise manager

• lnair123

  SSChasing Mays

  Points: 654

  More actions

  January 26, 2005 at 2:51 pm

  #110091

  hi,

  I am a sql server newbie. I have a question.How do you rebuild indexes (all indexes) on a database using enterprise manager? I would like to run this as a job.

  thanks,

  Pn123

• David Todd

  SSC Veteran

  Points: 266

  More actions

  January 26, 2005 at 10:35 pm

  #539268

  Hi,

   

  From query analyser you can do this:

  execute sp_msforeachtable 'dbcc dbreindex( [?] )'

  You can schedule this as a job by entering this as the query in the job-step.

   

  Or you can achive the same result by creating a maintenance plan(Management | Maintenance Plans) that does Reorganise data and index pages.

   

  On completing the maintenance plan wizard, jobs which schedule this are created.

   

  HTH

    Regards

    David