SQL Log 2

[telcomwork]

Is there a log to see all changes made to a particular DB that were made via Enterprise Manager and modifying the table?

 

[mrdenny]

That would be the transaction log. You'll need something like Lumigent's Log Explorer to view the transaction log.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[SQLWilts]

MrD - the transaction log only logs inserts, updates or deletes to data.
If you are looking for more detail - as in any and all changes, you have to turn on C2 auditing. Look it up on google or a search engine. Be aware that there is a HEAVY disk cost associated with turning it on though.
SQL server logs will give you some info, but not a lot (under management in enterprise manager)

 

[telcomwork]

Thanks all!

 

[mrdenny]

The transaction log logs all DML and all DDL commands including alter table commands. How else would log shipping get schema changes.

C2 auditing is very CPU and disk intensive and should only be used in very specific circumstances. It's also useless to tracking changes which have already happened as it's simply running a SQL Trace to disk for each command.

On high load SQL Servers C2 auditing will kill the SQL Server.

In order to view the changes which have happened in the past the database must be in full or bulk logged recovery mode.

C2 auditing will also not do anything for you if you are still running on SQL 7 as it was first introduced in SQL 2000.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[SQLWilts]

I agree with all that MrDenny has said - as I said - google it - and don't take it lightly.
Government departments are the only organisation that I know of that utalise this.
But really, you could be on a loser if you are trying to trap something that has already happened.