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

    Unanswered: Rebuild Index Script


    Does anyone have Rebuild Index Script for entire database?

    Thanks in advance...j

  2. #2
    Join Date
    Apr 2002
    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.


Posting Permissions

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