Log activities

With the exception of the Profiler, is there another way
to monitor the transaction taking place on the server? I
want to be able to see what users are doing like which
commands they executed and if it fails or not.
Thanks
EmmaEmma,
there are several third-party tools to do this sort of thing eg LogExplorer
could be useful - either looking at historical logs or real-time:
http://www.lumigent.com/products/le_sql/le_sql.htm.
Regards,
Paul Ibison

Log activities

With the exception of the Profiler, is there another way
to monitor the transaction taking place on the server? I
want to be able to see what users are doing like which
commands they executed and if it fails or not.
Thanks
Emma
Emma,
there are several third-party tools to do this sort of thing eg LogExplorer
could be useful - either looking at historical logs or real-time:
http://www.lumigent.com/products/le_sql/le_sql.htm.
Regards,
Paul Ibison