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.