Urgent - How to get the Query Execution History

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mo - 15 Jul 2008 21:11 GMT

Hi,

We are trying to trouble shoot a problem and we are not sure what is
the queries that the application sending to my sql server. is there a
way to audit the queries executed by SQL Server?

Thanks

Reply to this Message

Denny Cherry - 15 Jul 2008 21:33 GMT

You can start up SQL Profiler and use it to see what commands are
being executed in real time.

Denny

>Hi,
>
[quoted text clipped - 3 lines]
>
>Thanks

Reply to this Message

Plamen Ratchev - 15 Jul 2008 21:52 GMT

You can use SQL Server Profiler:
http://msdn.microsoft.com/en-us/library/ms187929.aspx

On a production server is best to use server side trace:
http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm

HTH,

Plamen Ratchev
http://www.SQLStudio.com

Reply to this Message

Mo - 15 Jul 2008 22:23 GMT

Does it work on SQL 2000? following query works in 2005 but not in 2000

Reply to this Message

Linchi Shea - 16 Jul 2008 13:45 GMT

> Does it work on SQL 2000?

What is it? SQL2000 has its version of profiler or SQL Trace. This is an
inherent part of the product.

Linchi

> Does it work on SQL 2000? following query works in 2005 but not in 2000

Reply to this Message