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...
> was
>
>
|||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...[vbcol=seagreen]
> Thanks. Is there a way to trace DML on this table?
> "Aaron [SQL Server MVP]" wrote:
third[vbcol=seagreen]
it[vbcol=seagreen]
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment