I'm trying to figure out how an application is inserting data into the backend, so I ran a trace. I suspected that the app was calling a stored procedure, but all I found in the trace were a bunch of selects and inserts. Does Profiler only show the SQL of the Stored Procedures, or would the SP's name be shown? If just the SQL is shown, is there a way for me to find out which SP is producing the statements? Thanks in advance.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL Profiler Question
- Thread starter eao
- Start date
This will help but it isn't conclusive. Right click the table in EM, select All Tasks, select Display Dependencies.
-Karl
[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]
-Karl
[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]
If you have told profiler you want the stored procedure name it will give it to you.
Many applications however do not use stored procedures. Especially I've noticed the ones which run on multiple database back ends usually have all their code encapulated in the user interface.
Questions about posting. See faq183-874
Many applications however do not use stored procedures. Especially I've noticed the ones which run on multiple database back ends usually have all their code encapulated in the user interface.
Questions about posting. See faq183-874
- Status
Similar threads
- Locked
- Question