Friday, March 9, 2012

Is there any way to know the last access time of a table?

I have some junk tables in my database, but I am not sure if they are really not in use.

Does sql server log the last time that a table gets accessed? when I say access I mean any actions toward the table, including select, update, insert, etc.

thanks in advance.

I am unsure about your answer, but you can log it manually to a table by generating stored procedures for selecting/updating/etc.

|||thanks for the suggestion. I thought about that too but I can't possibly rewrite all codes across the application for this. also it may be too resource intensive. shouldn't there be a way to check the last access in sql server? apparently in the file-based system you can do so.

No comments:

Post a Comment