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) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
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