Roger Alcindor
asked on
Analysis of table use
I am using Microsoft SQL Server 2005. I need to know the most recent date/time when each table was last opened. Is there a utility or query that can provide this information ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Unfortunately, I did mean queried and not all tables are indexed so it looks like I'm out of luck.
So what is your next question now? Do you some issue
ASKER
No further question, as you said "if it is last queried, you are not lucky, there is no such option in sql server".
Great, if you have no further questions.
Regards,
pawan
Regards,
pawan
ASKER
As you say there is no such option in SQL server
Note - Groups is the table Name-
Open in new window
o/p
TableName CreatedDate ModifiedDate name object_id principal_id schema_id parent_object_id type type_desc create_date modify_date
Groups 2016-11-01 18:02:53.963 2016-11-01 18:02:53.963 Groups 267147997 NULL 1 0 U USER_TABLE 2016-11-01 18:02:53.963 2016-11-01 18:02:53.963
Try2... for more details.. you should use sys.dm_db_index_usage_stat
Open in new window
o/p
DB TableName LastLookUp LastScan LastSeek
ABCInvestment Groups NULL 2016-11-01 18:46:40.443 NULL
Hope it helps !!
Let me know if you need more info here.