• I got below mentioned query which will give list of unused table since the SQL services started.It is for MSSQL 2005. Is there any way to get list of unused stored procedures?

    SELECT DISTINCT OBJECTNAME = OBJECT_NAME(I.OBJECT_ID),I.OBJECT_ID

    FROM SYS.INDEXES AS I

    INNER JOIN SYS.OBJECTS AS O

    ON I.OBJECT_ID = O.OBJECT_ID

    WHERE OBJECTPROPERTY(O.OBJECT_ID,'IsUserTable') = 1

    AND I.OBJECT_ID

    NOT IN (SELECT DISTINCT I.OBJECT_ID

    FROM SYS.DM_DB_INDEX_USAGE_STATS AS S ,SYS.INDEXES AS I

    WHERE S.OBJECT_ID = I.OBJECT_ID

    AND I.INDEX_ID = S.INDEX_ID

    AND DATABASE_ID = DB_ID(db_name()))