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 last
> 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?|||Thanks, guys for you help. I am doing an audit of the sql farm and some of
the database has been left there for years and nobody knows what they are.
Stilt we just can't delete them. I do run profiler on the servers I am
working on to find out who logs in/out and log the data for further analysis.
But what I wanted is just from looking at the random database determine when
it is accessed/updated last and by whom. Some of the datatabase have the
AuditTrail tables and DateDelete/Added in the columns and I can determine
this information but other databases don't.
Anyway, thanks a log 4 your prompt response.
"Jerry Spivey" wrote:
> 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