SQL Server SQL Query Log


I have several databases in SQL Server. Is there a place that SQL Server keeps a log of each SQL query it executes for a particular DB? If so, how and where can I access it?

Who is Participating?
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
no, there is no log kept (automatically), at least not for SELECT queries.
the others (UPDATE, INSERT, DELETE) are stored in the transaction log, where you need some 3rd party tools to get them.

you can trace all queries using the query profiler, however that is not recommended to run all the time only for tracing, it's rather used to find problem sql at short term.
Aneesh RetnakaranDatabase AdministratorCommented:
Hi gregca80,
the log file of each database contains the queries executed on that particular database.
if you want to view the contents of this log, you can make use of third party tools such as Lumigent Log explorer
Aneesh RetnakaranDatabase AdministratorCommented:
Another freeware tool similar to SQL profiler is 'SQLSPY'
aneesh - the log file is continously pruned depending on several options (recoverability settings, recovery mode, transactions being completed, etc). So this option is not what he is looking for. He is looking for ALL queries ever run on that database.
All Courses

From novice to tech pro — start learning today.