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