[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 398
  • Last Modified:

Where to find MS SQL Transactions Log

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
gmhawash
Asked:
gmhawash
1 Solution
 
Anthony PerkinsCommented:
It is not the transaction log.  You use MS SQL Server Profiler to view the actual queries sent.
0
 
rob_farleyCommented:
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
 
gmhawashAuthor Commented:
Thank you for the help.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now