andres descalzo
andres descalzo

Reputation: 14967

Log in SQL Server Express for audit

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

Thank you.

Upvotes: 0

Views: 1841

Answers (3)

silent
silent

Reputation: 3923

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

Upvotes: 1

Espo
Espo

Reputation: 41939

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/

Upvotes: 1

Mark
Mark

Reputation: 108567

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

Upvotes: 0

Related Questions