General information
Forum:
Microsoft SQL Server
Category:
Database management
Title:
Tracing SQL Server Transaction Log
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only