Hi,
Does anyone have Rebuild Index Script for entire database?
Thanks in advance...jIf 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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment