InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 12:48:36 GMT20http://www.sqlservercentral.com/Forums/Topic861979-1407-1.aspxI have been working through this article and have found very instructional and also useful. I have not noticed anyone having problems with proc_InsertMostUsedIndexes. I am stuck. Whenever I run it I get the following error:Msg 512, Level 16, State 1, Procedure proc_InsertMostUsedIndexes, Line 12Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.I am at a deadend so if anyone could give me any help it would be greatly appriciated.Thanks in advance.;-)Mon, 08 Feb 2010 12:45:52 GMTSQLCrazy