(DIR) Return Create A Forum - Home
       ---------------------------------------------------------
       ExcelSoft Database Professionals
 (HTM) https://esdbp.createaforum.com
       ---------------------------------------------------------
       *****************************************************
 (DIR) Return to: Scripts
       *****************************************************
       #Post#: 12--------------------------------------------------
       Index Information including included,filtered,column indexes 
       By: srinivasma_exceldbp Date: February 27, 2014, 12:56 am
       ---------------------------------------------------------
       sp_helpindex  from Microsoft  provides only key columns
       Attached script provides iIndex Information including
       included,filtered,column indexes
       There are 3 different versions
       1. sql 2005 : sp_lib_helpindex2005
       2. sql 2008 : sp_lib_helpindex2008
       3. sql 2012 : sp_lib_helpindex2012
       sp_lib_ExposeColsInIndexLevels  is called by all the above SPs
       *****************************************************