Home Forums SQL Server 2008 SQL Server 2008 - General How do we get which tables / procedure / views / functions are not used more than 2 months? RE: How do we get which tables / procedure / views / functions are not used more than 2 months?

  • Thanks for all swift response I hope we better to go with DB level audit and wait for few months and let us query from the Output file.

    Because : some of table don't have clustered or non cluseterd index so we cannot say100% , and also if Proc cache changed or cleared it would be partial also :-).

    I am going to start DB Audit with DDL and changes and Access of any schema pattern.