Solved

Determine Stored Proc from ASP.NET

Posted on 2013-06-07
3
296 Views
Last Modified: 2013-06-27
Hi All,

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?
0
Comment
Question by:Kyle Abrahams
  • 2
3 Comments
 
LVL 75

Accepted Solution

by:
käµfm³d   👽 earned 500 total points
ID: 39230682
If you have SA to the database (I won't question as to why : \ ), would it be possible for you to run the SQL Server Profiler utility?

Screenshot
You can set up a new trace for that server, which should show you what queries are hitting the database. I've only ever connected with Windows authentication, but I believe you can specify a database account as well.
0
 
LVL 40

Author Comment

by:Kyle Abrahams
ID: 39245736
Hi Kaufmed,


I'll check it out.  This would be on production and forget if profiler has a performance impact.

Are there any risks?

Sorry for the late reply.  We got another project dumped on us that needs to be done ASAP.  Responses may be a bit slow but will get to this soon.
0
 
LVL 40

Author Comment

by:Kyle Abrahams
ID: 39281756
No real perfromance impacts when running the profiler.  The only thing to watch out for is it writes to the C Drive when saving the data, so that can be problematic (in my case I only had 1.7 GB free . . . 12GB System partition) as I ran out of space.  Clearing the trace window will free up the space.

Thanks for the help.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to repeat the data 4 30
Upgrade code from VS 2010 to VS 2015 7 32
Problem to Office 1 40
SSRS 2013 - Finding Datasets/StoredProcedures 4 33
Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

735 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