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?
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?
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment