Logging SQL Queries

Hi,

I′m currently playing around with ASP.NET.

Is there a way to log all Queries that are send to the SQL-Server? Something like the query.log of a Mysql.

You can write your own logging system (I have done that when working with dynamic TSQL), however you can just run a SQL Trace from within SQL Server.

|||

Thanks for your reply.
An own logging system won′t help if I use, for example, a sql datasource for a gridview. It would bypass the logging class.
I′ve searched the onlinehelp and it seems, that a SQL Trace is a bit overpowered for a simple querylog.

|||

>I′ve searched the onlinehelp and it seems, that a SQL Trace is a bit overpowered for a simple querylog.

You would need to tune one of the standard selection else otherwise the volume of log data would be overwhelming.