>Hi All,
>
>I am new DBA working for 3 months. I previously worked as a developers for 5 years.
>As a new DBA I want to know the activity of the SQL Server.
>
>Anybody from there can give idea how I can trace the logs of sql server.
>I know that i can use the dbcc log([database ID]) but it is not detailed.
>
>I want to trace the transaction log of the server such as user updating data, deleting or inserting data.
>I want also to know who drops the table in the database because it happens that there is a table in the database drop by somebody.
>
>Anybody can help me?
>
>
Hi Rene,
Check Log Explorer for SQL Server from
http://www.lumigent.com/products/le_sql.html. It can do all you listed and more.
--sb--