Solved

MSSQL Server Query viewer

Posted on 2009-07-10
3
206 Views
Last Modified: 2013-11-05
Is there any tool available to show every SQL statement that is executed on MS SQL Server. I would like to know what statements where executed for debuging purposes.
0
Comment
Question by:uveper
3 Comments
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 250 total points
ID: 24821181
check out the Sql Profiler, it can trace all sql run against your sql instance
0
 
LVL 17

Expert Comment

by:k_murli_krishna
ID: 24821277
0
 

Author Closing Comment

by:uveper
ID: 31601973
Thank you for the anwser!
I would also like to say thanks to other users response (sorry but angelIII was first)
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question