When trying to bring your functions to 'life', I changed the proc_FilltblIndexUsageInfo

ALTER Proc [dbo].[proc_FilltblIndexUsageInfo]

AS

Begin

Truncate table tblIndexUsageInfo

insert into tblIndexUsageInfo

select db_name(db_id()) DbName,

so.name as 'TableName',

ISNULL(si.name,'No Index') as IndexName,

si.index_id,

Case When is_primary_key=1 then 'Primary...