Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rieta760
Starting Member
5 Posts |
 Posted - 2008-02-28 : 11:34:02
|
| I am attempting to see if an application is calling a particular stored proc. i have the Profiler setup to only display the login and it is. I have all items set to display under Stored Procedures, but I can't see names of procedures in the Text Data. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-02-28 : 11:36:43
|
How are the calls to SPs made? With RPC or directly?Check out both SQL* AND SP* events.If using RPC, check out RPC* events.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-28 : 11:39:55
|
| Did you capturing the SP:Starting or SP:Completed events? The Text column has the full name of the stored procedure, the Database ID column has the database name, and the Object ID column has the object ID. |
|
|
|
rieta760
Starting Member
5 Posts |
Posted - 2008-02-28 : 11:53:39
|
quote:
Originally posted by sodeep
Did you capturing the SP:Starting or SP:Completed events? The Text column has the full name of the stored procedure, the Database ID column has the database name, and the Object ID column has the object ID.
I am capturing everything under the Stored Procedure section. |
|
|
|
rieta760
Starting Member
5 Posts |
Posted - 2008-02-28 : 12:09:20
|
| hmm.. my proc is now showing thanks all. it was under RPC. Now I'm trying to just show the RPC call, filtering on TEXT DATA where like 'name of proc' but it shows nothing.. suggestions? |
|
|
|
|
|
|
Can't see procedure calls in Profiler, HELP