Link to home
Start Free TrialLog in
Avatar of notta3d
notta3dFlag for United States of America

asked on

Find SQL query used by application

We use an enterprise application that uses MSSQL for the database. We would like to access the data directly instead of using the applications built in reports so we can add the data to our workflows. Using their tool and having to export is not ideal so we would like to query the database directly. We asked them about accessing the data directly and they said the data is very normalized. I'm sure it's just that they don't want us screwing with the database.

Is there a way to find out what query the reports are running? I am competent working with SQL but not an advanced user. I thought I remember SQLMMS having a utility showing all queries run against the server? Does anyone have any recommendations how I would go about finding this information? Thanks.
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Is there a way to find out what query the reports are running?
Easy way is to use SQL Profiler to capture the queries.
ASKER CERTIFIED SOLUTION
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of notta3d

ASKER

This is exactly what I need. Thanks!