Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Profiler Event: SP:StmtStarting with TextData but empty ObjectName Expand / Collapse
Author
Message
Posted Wednesday, March 09, 2011 12:35 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, March 27, 2014 11:01 AM
Points: 60, Visits: 226
Hello,

Tracing a process in Profiler, but, I found for an event:

SP:StmtStarting in the EventClass
Valid SQL stmt exists in the TextData
However, in the ObjectName column, there is no stored procedure name?

What is it refering to.

I have searched for this SQL in the stored procedures in our DB, but couldn't find it. So, how is this possible?

Thank you.
Post #1075817
Posted Wednesday, March 09, 2011 12:43 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 11:15 AM
Points: 177, Visits: 246
you should have an RPC:Completed event (assuming you are tracing it) after your event in question with the same SPID. That is the calling procedure.



--------------------------------------------------------------------------
When you realize you've dug yourself into a hole....Step 1...stop digging.
Post #1075828
Posted Wednesday, March 09, 2011 12:56 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, March 27, 2014 11:01 AM
Points: 60, Visits: 226
ok...

It says: exec sp_executesql N'....

Does it mean a dynamic sql sent from the client instead of a stored proc...

thanks again
Post #1075846
Posted Wednesday, March 09, 2011 12:58 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 11:15 AM
Points: 177, Visits: 246
it does mean dynamic SQL. It can be in a stored procedure or the client, but since you searched the database I would say it is definitely the client.



--------------------------------------------------------------------------
When you realize you've dug yourself into a hole....Step 1...stop digging.
Post #1075849
Posted Wednesday, March 09, 2011 1:07 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, March 27, 2014 11:01 AM
Points: 60, Visits: 226
Great! Thank you so much.
Post #1075854
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse