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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 profiler and stored procedures

Author  Topic 

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2008-07-23 : 12:52:27
when i open a profiler ,is there a way to see all the command that the Stored procedure makes,and all the commands that another Stored procedure that is called from the first one makes too?

thnaks in advance
peleg

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-07-23 : 13:00:24
Yes, you need to select

SP:StmtStarting and SP:StmtCompleted

Rpc:Starting and RPC:completed for remote procedure call.
Go to Top of Page

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2008-07-23 : 17:05:37
10X:)

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-07-23 : 17:25:33
I just use the Completed ones as I don't want the duplicates of Completed and Starting.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -