Determine Stored Proc from ASP.NET
Posted on 2013-06-07
I'm trying to do some reporting on a 3rd party application.
I have admin access to the front end and SA for the backend.
The application dumps some data to a CSV, which our users manually use to crunch numbers in different ways . . . I'm trying to automate that process to reduce the errors and time.
My issue is the web app is pre-compiled. It looks like the application has a default page, which then takes a query string of a pageID to load the page from the database.
All of that to say that I'm trying to find out what stored procedure / query is being run against the DB to generate the data.
The applicaiton is quite large (a few hundred stored procs) with a number of tables and trying to parse out the information in a meaningful way is going to be a pain, so trying to short cut it. Getting help from the vendor is NOT possible.
I thought of SP_who2 . . . but that doesn't give me the info I need. DB and front end are on different boxes.
Any thoughts on how about going to extract the stored proc / query from a dynamically loaded page?