Log in SQL Server Express for audit

Question

It is possible in SQL Server Express have a log of all operations "SELECT / UPDATE / INSERT / DELETE" being made.

Thank you.

Answer 1

You need to run SQL Server Profiler, though. Freeware alternative is here

Answer 2

We use something similar to this with SQL Server 2005. It should work in the express edition.

Answer 3

If you are using the express edition you do not have "SQL Server Profiler". But here is a free open source alternative:

http://code.google.com/p/sqlexpressprofiler/