Home Forums SQL Server 2005 Administering Deleting the tables which are not been used from long time. RE: Deleting the tables which are not been used from long time.

  • October 10, 2012 at 8:10 am

    #1547667

    ksr39 (10/10/2012)

    Thank You Bhuvnesh for the quick reply,

    But it’s difficult to find the table which is not been used more than a month as my server was rebooted since 65 days. If I can get an exact table names so that I can change their names it’s a good thing but when I am not sure with the table name then it will be over work in doing this. So is there any way other than this where I can get the tables info which are not been used more than a month or more.

    Thank you in Advance

    if an application is depreciated why the relavent tables not deleted from production server or any debugging happening directly on production server?

    Regards
    Durai Nagarajan