Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Posts
    60

    Unanswered: Rebuild Index Script

    Hi,

    Does anyone have Rebuild Index Script for entire database?

    Thanks in advance...j

  2. #2
    Join Date
    Apr 2002
    Posts
    10
    If your are speaking of a DBCC DBREINDEX script you could take a look at BOL under DBCC SHOWCONTIG for a nifty script that would do the trick.

    If your are speaking of how to script all indexes in your database you could you EM to do that. Just select all the tables, right click, and under Task you will find generate script. Do that and then clean out all the DDL you do not want.

    Sarah

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •