sql server programming: Tables last accessed -- sql server programming

Re: Tables last accessed

Simon Worth
3/31/2005 8:00:32 PM

sql server programming:

no, it's not tracked. You'd have to use profiler to track something
like that.
You can monitor mods to data using triggers and indicator columns, but I
don't think that's what you're looking for.

Simon Worth

[quoted text, click to view]

Tables last accessed

William F. O'Neill
3/31/2005 9:39:59 PM

I would like to know if I could find out the date a table was last accessed.
If so, could you give me some script to do this?

Re: Tables last accessed

Aaron [SQL Server MVP]
3/31/2005 9:56:50 PM

No, SQL Server does not track this information.

There was a thread earlier today... When was an SP last run?

Basically, you can use profiler, a 3rd party auditing tool like Entegra, add
custom auditing to the stored procedure(s) that touch the table(s), or use
triggers.

A

On 3/31/05 9:39 PM, in article eIooZQmNFHA.1500@TK2MSFTNGP09.phx.gbl,
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server programming group.