The script did not work for me on SQL Server 2008.
After I added an extra JOIN to sys.SCHEMAS in the next piece of the script it did not give any runtime errors.
------------------------------------------------------------------------
-- UPDATING the number of NONCLUSTERED INDEXES per TABLE
------------------------------------------------------------------------
UPDATE #ClusteredIndexes
SET NonClusteredIndexCount = ISNULL((
SELECT 'NonClusteredIndexCount' = COUNT(*)
FROM sys.INDEXES I
JOIN sys.OBJECTS O-- Joining on sys.OBJECTS to get the TableName
ON O.OBJECT_ID = I.Object_ID
JOIN sys.SCHEMAS S
ON S.schema_id = O.schema_id
--AND S.name = @strSchemaName
WHERE I.type = @NonClusteredIndexType
AND QUOTENAME(O.Name) = T.TableName
AND QUOTENAME(S.Name) = T.SchemaName
GROUP BY I.object_id),0)