|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
|
|
|
||||||
 |
|
|
LinkBack | Outils de la discussion |
15/07/2008, 22h11
|
#1 |
Messages: n/a
Hébergeur: |
Urgent - How to get the Query Execution History
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 |
|
|
15/07/2008, 22h33
|
#2 |
|
Messages: n/a
Hébergeur: |
Re: Urgent - How to get the Query Execution History
You can start up SQL Profiler and use it to see what commands are
being executed in real time. Denny On Tue, 15 Jul 2008 13:11:33 -0700 (PDT), Mo <theguzu@gmail.com> wrote: >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 |
|
|
|
15/07/2008, 22h52
|
#3 |
|
Messages: n/a
Hébergeur: |
Re: Urgent - How to get the Query Execution History
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...sql_server.htm HTH, Plamen Ratchev http://www.SQLStudio.com |
|
|
|
15/07/2008, 23h23
|
#4 |
|
Messages: n/a
Hébergeur: |
Re: Urgent - How to get the Query Execution History
Does it work on SQL 2000? following query works in 2005 but not in 2000
|
|
|
|
16/07/2008, 14h45
|
#5 |
|
Messages: n/a
Hébergeur: |
Re: Urgent - How to get the Query Execution History
> 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 "Mo" wrote: > Does it work on SQL 2000? following query works in 2005 but not in 2000 > |
|
|
|
| Outils de la discussion | |
|
|
