How to find unused tables

All replies

• 

  

  0

  Sign in to vote

  If you have SQL profiler traces for that period , you may look in to it and see whether or not the objects were accessed .

  ---

  Thanks, Leks

  Thursday, December 3, 2009 8:57 AM
• 

  

  0

  Sign in to vote

  For tables, you would have to take a snapshot of the database (backup db, restore it as copyofdb) and do a compare a month later for example with a tool like SQL Data Compare.
  
  Unused stored procedure check is tough.
  
  You may do this:
  
  1. Have DBA monitor specific sprocs with SQL Server Profiler for a week
  2. If monitored sprocs do not show up in trace, rename them
  3. Delete renamed sprocs 3 months later

  ---

  Kalman Toth, SQL Server & BI Training, SSAS, SSIS, SSRS; http://www.SQLUSA.com

  • Marked as answer by Zongqing Li Wednesday, December 9, 2009 8:28 AM

  Thursday, December 3, 2009 9:01 AM
• 

  

  1

  Sign in to vote

  Hello,
  
  
  You could try the below work around.
  
  http://www.sqlservercentral.com/articles/Administration/2582/
  
  
  Thanks,
  Krishna
  www.SQLServer.in
  http://Blogs.SQLServer.in

  • Proposed as answer by Naomi N Thursday, December 3, 2009 2:30 PM
  • Marked as answer by Kalman Toth Tuesday, April 17, 2012 7:43 PM
  • Unmarked as answer by Kalman Toth Tuesday, April 17, 2012 7:44 PM

  Thursday, December 3, 2009 9:52 AM