Saturday, February 25, 2012

Monitor a SQL table

Is there a way that I can monitor a table on SQL server. Specially if the t
able get change, then it will log who change it and what's been insert to th
e table?http://www.aspfaq.com/2448
http://www.aspfaq.com/2496
http://www.aspfaq.com/
(Reverse address to reply.)
"Dave" <Dave@.discussions.microsoft.com> wrote in message
news:CCC17ADE-6083-4A48-88E1-5F2261539410@.microsoft.com...
> Is there a way that I can monitor a table on SQL server. Specially if the
table get change, then it will log who change it and what's been insert to
the table?
>|||Do you mean the table schema changes or do you mean that data in the table
changes?
If data, simply add a trigger and capture the user's identity.
"Dave" <Dave@.discussions.microsoft.com> wrote in message
news:CCC17ADE-6083-4A48-88E1-5F2261539410@.microsoft.com...
> Is there a way that I can monitor a table on SQL server. Specially if the
table get change, then it will log who change it and what's been insert to
the table?
>

No comments:

Post a Comment