auditing a hosts activities 1

[IanStrange]

Hi
In my previous post I wanted to limit a host activities. I am assuming by the lack of respons that it is not possible. Is it possible to audit that hosts activities instead.
Thanks
Ian Strange

No man is an island but 6 tied together make quite a good raft.

 

[JoeSack]

Hi,

I didn't see your previous post - but regarding the monitoring of a host's activity, you can use SQL Profiler (either the client tool, or a server-side trace).

You can then filter the hostname to be equal to the host you wish to monitor. This assumes you are concerned with monitoring the various SQL Server related events that are viewable with SQL Profiler.

Best Regards,
Joseph Sack,

http://www.JoeSack.com

Author of "SQL Server 2000 Fast Answers for DBAs and Developers".