Here the worling Skcript on SQL Server 2008:

Create Table tblIndexUsageInfo

(

Sno int identity(1,1),

Dbname Varchar(100),

TableName varchar(100),

IndexName Varchar(300),

Index_id int,

ConstraintType varchar(25),

Type_desc varchar(100),

IndexKeyColumn Varchar(1000),

IncludedColumn Varchar(1000),

user_seeks int,

user_scans int,

user_lookups int,

user_update int,

IndexUsage int,

IndexSizeKB int,

IndexUSageToSizeRatio decimal(10,2),

IndexSelectionCrieteria int

)

GO

CREATE FUNCTION...