sp_helpindex stored procedure improvements

When SQL Server introduced the concept of included columns in indexes in SQL Server 2005, they didn't really provide any way to get information on the included columns on an index. Kimberly L Tripp created help index 2 to enhance help index. Since then there have been a number of further changes to this stored procedure and even a help index 3.

Download the one that suits you best and add it to your toolkit.

I would also book mark SQL Skills as an excellent resource

https://www.sqlskills.com/