Solved

Where to find MS SQL Transactions Log

Posted on 2009-07-12
3
381 Views
Last Modified: 2013-12-12
I am developing an ASP.NET app with MS SQL database.  I want to know what are the queries that are sent to the DB from the ASP.NET app and be able to view them along with whatever parameters were passed.  I cannot figure out why a DataSource is not responding as I expect and want to know what is ASP.NET sending to the DB.

Where can I find such transaction log, and what tool do I use to view them.

Thanks,
0
Comment
Question by:gmhawash
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 24836287
It is not the transaction log.  You use MS SQL Server Profiler to view the actual queries sent.
0
 
LVL 15

Accepted Solution

by:
rob_farley earned 250 total points
ID: 24837840
So... run Profiler - it's under "Performance Tools" in the Start Menu, under SQL Server 2005.

Then start a trace, connecting to your server. Best if you filter it to only connections from your web server. Grab the RPC:Completed and SQL:BatchCompleted events for a start - show all columns and tick what you're interested in seeing.

Now watch the commands come in. Stop it when you've seen enough, as it can cause a performance hit.

Rob
0
 

Author Closing Comment

by:gmhawash
ID: 31602645
Thank you for the help.
0

Featured Post

Free NetCrunch network monitor licenses!

Only on Experts-Exchange: Sign-up for a free-trial and we'll send you your permanent license!

Here is what you get: 30 Nodes | Unlimited Sensors | No Time Restrictions | Absolutely FREE!

Act now. This offer ends July 14, 2017.

Question has a verified solution.

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

Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
Developer portfolios can be a bit of an enigma—how do you present yourself to employers without burying them in lines of code?  A modern portfolio is more than just work samples, it’s also a statement of how you work.
The viewer will learn how to successfully download and install the SARDU utility on Windows 7, without downloading adware.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

734 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