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 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy