• Thanks for reply.

    I don't want to use profiler and create job for getting list of unused tables and stored

    procedures.

    Is there any other way to get list of tables and sps which are not being used since 6 months in mssql 2000 and mssql 2005?