Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Tool/Process to determine SQL Statements executed from Web Application

Posted on 2010-09-01
1
Medium Priority
?
414 Views
Last Modified: 2012-06-21
I'm using a web application that is written in ASP.NET and uses a SQL Server 2005 database. The application does not have an effeceint utility to import a large amount of users. I would like determine the SQL statements (INSERTS or UPDATES) used by the application to populate the database without decompiling the ASP.NET dll files. Is there a tool or process to track changes to a database that will help me determine what sort of SQL statements were executed by the web app?

I.E. When a new user is created in the web app, a new row is created in tables X,Y & Z and rows 1, 2 of table A was updated.
0
Comment
Question by:kmmc
[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
1 Comment
 
LVL 20

Accepted Solution

by:
Marten Rune earned 2000 total points
ID: 33578760
Use SQL profiler to capture these statements. Filter on the ASP.NET user, or the database.

Regards Marten
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
In this article I will describe the Copy Database Wizard 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.
This tutorial will introduce the viewer to VisualVM for the Java platform application. This video explains an example program and covers the Overview, Monitor, and Heap Dump tabs.
This tutorial explains how to use the VisualVM tool for the Java platform application. This video goes into detail on the Threads, Sampler, and Profiler tabs.

730 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