Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Urgent - How to get the Query Execution History

  
   Database Forums (Home) -> Server RSS
Next:  SQL 2005 - lLter Index hangs  
Author Message
Mo

External


Since: Jun 29, 2008
Posts: 11



(Msg. 1) Posted: Tue Jul 15, 2008 1:11 pm
Post subject: Urgent - How to get the Query Execution History
Archived from groups: microsoft>public>sqlserver>server (more info?)
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

 >> Stay informed about: Urgent - How to get the Query Execution History 
Back to top
Login to vote
Denny Cherry

External


Since: Jul 10, 2008
Posts: 9



(Msg. 2) Posted: Tue Jul 15, 2008 1:33 pm
Post subject: Re: Urgent - How to get the Query Execution History [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
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
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

 >> Stay informed about: Urgent - How to get the Query Execution History 
Back to top
Login to vote
Mo

External


Since: Jun 29, 2008
Posts: 11



(Msg. 3) Posted: Tue Jul 15, 2008 2:23 pm
Post subject: Re: Urgent - How to get the Query Execution History [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Does it work on SQL 2000? following query works in 2005 but not in 2000
 >> Stay informed about: Urgent - How to get the Query Execution History 
Back to top
Login to vote
Plamen Ratchev

External


Since: Nov 06, 2007
Posts: 352



(Msg. 4) Posted: Tue Jul 15, 2008 4:52 pm
Post subject: Re: Urgent - How to get the Query Execution History [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Back to top
Login to vote
Linchi Shea

External


Since: Mar 03, 2006
Posts: 234



(Msg. 5) Posted: Wed Jul 16, 2008 5:45 am
Post subject: Re: Urgent - How to get the Query Execution History [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
> 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
>
 >> Stay informed about: Urgent - How to get the Query Execution History 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Why is job history insert blocking? - SQL2005 EE I am seeing the following block excessively throughout day. Any ideas why? what can i do? tia Chris EXECUTE msdb.dbo.sp_sqlagent_log_jobhistory @job_id = 0x1B5CB78EFCD08241B30869DAF75B9723 , @step_id = 1, @sql_message_id = 0, @sql_severit...

Clear connection history - Hello Does anybody know how to clear the logon/connection history in SQL Management Studio 2005. Many thanks Darren

Job Change History - Anyone know how to tell who is changing a db maintenance plan? I found the system tables in msdb but I don't see how to tell who is doing it. Only when.

Urgent - General Network Error - Hi , I have a subscription that keeps failing to synchronise with the following error : "General Network Error. Check your network documentation" how can i check the cause & resolve ? kindly advise

urgent problem about SQL Server -
   Database Forums (Home) -> Server All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]