How can I tell if a table is regularly updated, or the last time that it was
updated?SQL Server doesn't track usage information by default. You can use a third
party product or build the tracking in yourself. Some treatments here:
http://www.aspfaq.com/2496
http://www.aspfaq.com/2448
--
http://www.aspfaq.com/
(Reverse address to reply.)
"NeverQuit" <NeverQuit@.discussions.microsoft.com> wrote in message
news:AC4F1032-96DF-4624-93E6-8AD3988EDA9D@.microsoft.com...
> How can I tell if a table is regularly updated, or the last time that it
was
> updated?|||Thanks. Is there a way to trace DML on this table?
"Aaron [SQL Server MVP]" wrote:
> SQL Server doesn't track usage information by default. You can use a third
> party product or build the tracking in yourself. Some treatments here:
> http://www.aspfaq.com/2496
> http://www.aspfaq.com/2448
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "NeverQuit" <NeverQuit@.discussions.microsoft.com> wrote in message
> news:AC4F1032-96DF-4624-93E6-8AD3988EDA9D@.microsoft.com...
> > How can I tell if a table is regularly updated, or the last time that it
> was
> > updated?
>
>|||You mean UPDATE, INSERT, DELETE? Yes, did you look at the links I posted?
--
http://www.aspfaq.com/
(Reverse address to reply.)
"NeverQuit" <NeverQuit@.discussions.microsoft.com> wrote in message
news:D7A04761-2125-4A4F-AF5C-9BCB47CB37EB@.microsoft.com...
> Thanks. Is there a way to trace DML on this table?
> "Aaron [SQL Server MVP]" wrote:
> > SQL Server doesn't track usage information by default. You can use a
third
> > party product or build the tracking in yourself. Some treatments here:
> >
> > http://www.aspfaq.com/2496
> > http://www.aspfaq.com/2448
> >
> > --
> > http://www.aspfaq.com/
> > (Reverse address to reply.)
> >
> >
> >
> >
> > "NeverQuit" <NeverQuit@.discussions.microsoft.com> wrote in message
> > news:AC4F1032-96DF-4624-93E6-8AD3988EDA9D@.microsoft.com...
> > > How can I tell if a table is regularly updated, or the last time that
it
> > was
> > > updated?
> >
> >
> >sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment