SQL Server 2005: Script all Indexes

• Sherbaz.com

  Valued Member

  Points: 61

  More actions

  March 12, 2015 at 4:53 am

  #1783543

  Hi,

  I have modified the script to output the files in a table format and posted in my blog.

  http://www.sherbaz.com/2015/03/list-out-and-script-all-indexes-in-a-database-for-excel-sheets/[/url]

  Have a look and let me know if you have any queries.

  Thanks and regards
  Sherbaz
  www.sherbaz.com
  

  
  Developer and DBA
  @
  
  www.splitexpense.in

• yan-160997

  Ten Centuries

  Points: 1179

  More actions

  December 31, 2015 at 8:58 am

  #1848957

  @r5d4, thank you for your information. I have the same problem, and ran your script. The script only generate the scripts for normal indexes, which does not include PK (clustered) in the index category. Any idea what to do?

  Thanks

  Yan