Monday, February 20, 2012

Need to track SQL activity

Hi all -
We are running a CRM application on a SQL 2K SP3a box. Through SQL, are
there any logs that I can go back to in order to see what data was viewed,
exported and by whom, for a specific date?
Thanks - MikeTransaction logs contain all the data modification information, but SQL
Server doesn't provide a friendly way to get at that information (DBCC LOG,
and fn_dblog are available).
Another approach would be to use Profiler or server side trace procedures to
capture the information you are after. For additinoal information on server
side traces, see:
http://vyaskn.tripod.com/server_sid..._sql_server.htm
--
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"HelpPls" <smd6169@.hotmail.com> wrote in message
news:uaczuKYeEHA.2532@.TK2MSFTNGP09.phx.gbl...
> Hi all -
> We are running a CRM application on a SQL 2K SP3a box. Through SQL, are
> there any logs that I can go back to in order to see what data was viewed,
> exported and by whom, for a specific date?
> Thanks - Mike
>
>

No comments:

Post a Comment