SQL Server Performance

What is the Best Way to Identify Unused Tables?

Discussion in 'What is the Best Way to Identify Unused Indexes?' started by mallik143_swa, Aug 30, 2007.

  1. mallik143_swa New Member

    How can we trace out Unused Tables in the SQL Server ?
    Please solve solve my issue ..
    Thank you
    Malli
    mallik143_swa, Aug 30, 2007
    #2

  2. Luis Martin Moderator

    Check:
    http://sql-server-performance.com/Community/forums/p/14520/73790.aspx#73790
    Luis Martin, Aug 30, 2007
    #3

  3. ndinakar Member

    rename it and see if your application fails. You can also query syscomments and see if the table is used in any procs. If you use adhoc TSQL in your app, then theres no direct way to find out.
    ndinakar, Aug 30, 2007
    #4

  4. satya Moderator

    What is the problem at the moment with these tables?
    Have they been created on fly and not used, if so why not look at the initial process to do so.
    satya, Aug 31, 2007
    #5

Share This Page