Monday, March 12, 2012

How to find out when the database has been accessed/updated last?

Hi all, is there a way to find out when the database has been accessed last
or when any of the tables has been updated recently?Look into C2 auditing
--
Thomas
"Ruski" wrote:

> Hi all, is there a way to find out when the database has been accessed las
t
> or when any of the tables has been updated recently?|||Ruski,
You would need to have had Profiler or some third-party auditing tool
running to determine this. Another option would be to use some extra
auditing code in the tables or use triggers. C2 is probably overkill for
this.
HTH
Jerry
"Ruski" <Ruski@.discussions.microsoft.com> wrote in message
news:206D75AD-7369-436F-8650-F52D8FA863BB@.microsoft.com...
> Hi all, is there a way to find out when the database has been accessed
> last
> or when any of the tables has been updated recently?

No comments:

Post a Comment