Log in SQL Server Express for audit

It is possible in SQL Server Express ha开发者_开发知识库ve a log of all operations "SELECT / UPDATE / INSERT / DELETE" being made.

Thank you.

---

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

---

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/

---

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