InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 03:55:43 GMT20http://www.sqlservercentral.com/Forums/Topic805745-1407-1.aspxPlease check that table tblIndexUsageInfo does not have a field by the name IndexSelectionCrieteriawhich you used on the UNION. If it is not a mistake please can you ALTER the Table and show us the value of the column? Otherwise the whole process is very neat. Procedure proc_FilltblUnusedIndexes (Manage Indexes)Tue, 20 Oct 2009 08:06:48 GMTINNOCENT GUMBO