October 29, 2012 at 10:39 pm
Comments posted to this topic are about the item Last Time a Table was Accessed
October 30, 2012 at 8:54 am
I think technically this is the last time the table was accessed since SQL was last (re)started.
SQL DBA,SQL Server MVP(07, 08, 09) "Money can't buy you happiness." Maybe so, but it can make your unhappiness a LOT more comfortable!
October 30, 2012 at 9:46 am
Thank you for this SQL. I have ben using internal calls to the SMO in databases to get this and other data in a development environment and have wondered how I can take the utility easily into production on a application server. I had looked into inclusion of the SMO dll in the bin directory and was not pleased with that solution at least not yet. But by using this type of query I may be able to eliminate the need for it. The use will depend on the ability to convert this to also list views, stored procedures, and triggers.
Thank you for at least exposing an option to look at.
Nice!
Not all gray hairs are Dinosaurs!
October 30, 2012 at 10:49 am
I couldn't found a way to list views access history.
The only thing I could find was to run a SQL audit.
October 30, 2012 at 10:53 am
I think you are correct.
May 9, 2016 at 1:21 pm
Thanks for the script.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply