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?

  • You need to set up some sort of auditing that captures every use of those objects. You can't do it retrospectively. Beware, you may find yourself capturing an awful lot of audit data!

    John