Solved

Determine Stored Proc from ASP.NET

Posted on 2013-06-07
3
291 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 74

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 39

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 39

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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my asp.net applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

762 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now