Solved

Tool/Process to determine SQL Statements executed from Web Application

Posted on 2010-09-01
1
405 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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

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 covers a step-by-step guide to install VisualVM launcher in eclipse.
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.

705 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

15 Experts available now in Live!

Get 1:1 Help Now