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?


TIA,


Rene