Solved

MSSQL Server Query viewer

Posted on 2009-07-10
3
186 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
Comment Utility
check out the Sql Profiler, it can trace all sql run against your sql instance
0
 
LVL 17

Expert Comment

by:k_murli_krishna
Comment Utility
0
 

Author Closing Comment

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

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Join & Write a Comment

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 this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

762 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now