notta3d
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.
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.
SQL Profiler to capture the queries.
Easy way is to use ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This is exactly what I need. Thanks!