March 9, 2011 at 12:35 pm
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.
March 9, 2011 at 12:43 pm
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.
March 9, 2011 at 12:57 pm
ok...
It says: exec sp_executesql N'....
Does it mean a dynamic sql sent from the client instead of a stored proc...
thanks again
March 9, 2011 at 12:58 pm
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.
March 9, 2011 at 1:07 pm
Great! Thank you so much.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply