Home Forums SQL Server 2005 Administering Enable/Disable all indexes in all tables at once RE: Enable/Disable all indexes in all tables at once

  • March 4, 2010 at 2:55 am

    #1128357

    You can use the undocumented procedure described here:

    http://solutions-guru.com/articles/sql-server/86-undocumented-procedure-spmsforeachtable-a-spmsforeachdatabase.html

    Regards,
    Sarabpreet Singh 😎
    Sarabpreet.com
    SQLChamp.com
    Twitter: @Sarab_SQLGeek