Locating strange updates

Is there any simple way in EM to put an audit on a field to see when
and what is updating it ?
Thanks"Nucleo" <nucleo@.gmail.com> wrote in message
news:1135001926.638640.188450@.g49g2000cwa.googlegroups.com...
> Is there any simple way in EM to put an audit on a field to see when
> and what is updating it ?
> Thanks
>
Not in EM, but you can do it in SQL Profiler. Of course the profiler will
need to be constantly running to perform this action.
The only other way is to create an UPDATE trigger on the table and have it
spit out the data somewhere. You can gather information from the System
functions like SUSER_SNAME and so forth in the trigger.
Rick Sawtell
MCT, MCSD, MCDBA|||There is no simple Enterprise Manager feature that can give you desired
results within a few minutes.
This article descibes how to implement data auditing using triggers:
http://msdn.microsoft.com/msdnmag/i.../04/DataPoints/
The following describes how to use SQL Profiler auditing events.
http://msdn.microsoft.com/library/d...>
erf_86ib.asp
http://msdn.microsoft.com/library/d...>
erf_6koi.asp
http://msdn.microsoft.com/library/d...>
erf_6zg3.asp
"Nucleo" <nucleo@.gmail.com> wrote in message
news:1135001926.638640.188450@.g49g2000cwa.googlegroups.com...
> Is there any simple way in EM to put an audit on a field to see when
> and what is updating it ?
> Thanks
>