Solved

Tool/Process to determine SQL Statements executed from Web Application

Posted on 2010-09-01
1
406 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
1 Comment
 
LVL 20

Accepted Solution

by:
Marten Rune earned 500 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

IntroductionWhile developing web applications, a single page might contain many regions and each region might contain many number of controls with the capability to perform  postback. Many times you might need to perform some action on an ASP.NET po…
Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
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.

867 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

21 Experts available now in Live!

Get 1:1 Help Now