Solved

Determine Stored Proc from ASP.NET

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

IntroductionWhile developing web applications, a single page might contain many regions and each region might contain many number of controls with the capability to perform  postback. Many times you might need to perform some action on an ASP.NET po…
Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
This is a video that shows how the OnPage alerts system integrates into ConnectWise, how a trigger is set, how a page is sent via the trigger, and how the SENT, DELIVERED, READ & REPLIED receipts get entered into the internal tab of the ConnectWise …

943 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

5 Experts available now in Live!

Get 1:1 Help Now