Solved

Tool/Process to determine SQL Statements executed from Web Application

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

Free Webinar: AWS Backup & DR

Join our upcoming webinar with experts from AWS, CloudBerry Lab, and the Town of Edgartown IT to discuss best practices for simplifying online backup management and cutting costs.

Question has a verified solution.

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

ASP.Net to Oracle Connectivity Recently I had to develop an ASP.NET application connecting to an Oracle database.As I am doing it first time ,I had to solve several problems. This article will help to such developers  to develop an ASP.NET client…
Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
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.

756 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