• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 417
  • Last Modified:

Tool/Process to determine SQL Statements executed from Web Application

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
kmmc
Asked:
kmmc
1 Solution
 
Marten RuneSQL Expert/Infrastructure ArchitectCommented:
Use SQL profiler to capture these statements. Filter on the ASP.NET user, or the database.

Regards Marten
0

Featured Post

The Lifecycle Approach to Managing Security Policy

Managing application connectivity and security policies can be achieved more effectively when following a framework that automates repeatable processes and ensures that the right activities are performed in the right order.

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