Post reply

Last Time a Table was Accessed

  • October 29, 2012 at 10:39 pm

    #266279

    Comments posted to this topic are about the item Last Time a Table was Accessed

  • October 30, 2012 at 8:54 am

    #1554206

    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) A socialist is someone who will give you the shirt off *someone else's* back.

  • October 30, 2012 at 9:46 am

    #1554243

    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

    #1554268

    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

    #1554270

    I think you are correct.

  • May 9, 2016 at 1:21 pm

    #1877587

    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