Can anyone tell me if there is a way to find out when a table was last accessed or updated. I dont think there is but thought I would give it a shot!I stew
I know you can possibly make use of the rowmodctr in sysindexes but that only hold IUD modifications and only since last stats were updated we were looking for something inclusive of selects and over a longer period.
If you allow access to data only through stored procedures, then you can log anything you want. Otherwise, you can only log through triggers, which means reading data goes unnoticed. You might figure out how to distill the information from a trace, but that will be pretty ludicrous - and why do it after the fact if you can do it up front - as in my first suggestion.