Design Errors : PK's with multiple columns on table with identity

-------------------------------------------------------------------------------------------------
-- Purpose: Gets tables that have an Identity together with a PrimaryKey with multiple columns
-- Reasoning: Generally, we expect a Primary Key on the Identity Column only, and if the table is clustered on the PK, this will fatten up the clustered index so fattening up all Indexes,
-- as well as introduce a column into the Clustered index which may undergo change, hence increasing the number of objects needing to be updated if an update occurs on that column.
-- Additionally, You could do identity insert and accidentally insert duplicate ID's into a table where the PK is ill-defined.
-- Author : Doran Mackay
--compatibility : should work on 2005+
-------------------------------------------------------------------------------------------------

select S.name+'.'+o.name TableName,I.Name IndexName,count(*) NumberOfColumnsInPrimaryKey
from sys.indexes I
inner join sys.index_columns INC on I.object_id = INC.object_id and I.index_id = INC.index_id
inner join sys.objects O on O.object_id = I.object_id
inner join sys.schemas S on o.schema_id = s.schema_id
inner join sys.identity_columns IC on i.object_id = IC.object_id
where is_primary_key = 1 and I.index_id = 1
group by S.name+'.'+o.name,I.Name
having count(*) >1