November 21, 2008 at 7:01 am
Hi
Has anyone found a way to check your database to find the last date a table was used, when a table does not have a date column. I trying to clean up the database and would like to remove the tables that haven't been used for this year. This is on a SQL 2000 database. Any suggestions?
Regards
Raymond
November 21, 2008 at 7:13 am
I don't know of anyway to reliably get this information from any of the system tables.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
November 21, 2008 at 7:41 am
That's the kind of information I miss from my AS/400 days
November 21, 2008 at 8:27 am
homebrew01 (11/21/2008)
That's the kind of information I miss from my AS/400 days
I don't miss mine at all. I can always write something in SQL Server that will do this for me. Plus, whose to say a table that hasn't been accessed in 6 months isn't still needed that 1 time a year?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply