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 MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Tracing Stored Procedure Call 1

Status
Not open for further replies.

kermitforney

Technical User
Mar 15, 2005
374
US
I am fiddling around with SQL Profiler (2000) and was wondering how I would track an individual remote procedure call. Is there a way to input the ObjectID or procedure ID to track the stored procedure call?
 
you can add the text as a filter and specify like '%yourProcName%' you can do this will all the fields.

If [blue]you have problems[/blue], I want [green]source code[/green] AND [green]error messages[/green], none of this [red]"there was an error crap"[/red]
 
I tried this the first time, but without the wildcards. I'll give it another try.

FYI ~ I love that you made your message to me a permanent sig!! :eek:D

Thanks again Qik3.
 
That wasn't you. I get this at work.

If [blue]you have problems[/blue], I want [green]source code[/green] AND [green]error messages[/green], none of this [red]"there was an error crap"[/red]
 
Haha, you too! :eek:) Well thanks for allowing to feel special if only for a brief moment.

So . . I placed the wild cards in there and they appear to have no effect.

Selected Event Classes:

StoredProcedures>RPC:Completed, RPCStarting, SP:Completed, SP:Starting

Filters applied:
ObjectName>Like>%sprname%

Any Suggestions?
 
Have you tried just searching for things you/person with issues are running? Try to eliminate everything else in otherways if directly specifying the text as whatever.


oooh, go to "Column Filters" down on the lower right of that screen. Select TextData and put your query name in there.


If [blue]you have problems[/blue], I want [green]source code[/green] AND [green]error messages[/green], none of this [red]"there was an error crap"[/red]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top