Solved

Determine Stored Proc from ASP.NET

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
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…

808 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