InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 06:28:37 GMT20http://www.sqlservercentral.com/Forums/Topic1075817-391-1.aspxGreat! Thank you so much.Wed, 09 Mar 2011 13:07:09 GMTmymail.defaulthttp://www.sqlservercentral.com/Forums/Topic1075817-391-1.aspxit 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.Wed, 09 Mar 2011 12:58:28 GMTChazManhttp://www.sqlservercentral.com/Forums/Topic1075817-391-1.aspxok...It says: exec sp_executesql N'....Does it mean a dynamic sql sent from the client instead of a stored proc...thanks againWed, 09 Mar 2011 12:56:59 GMTmymail.defaulthttp://www.sqlservercentral.com/Forums/Topic1075817-391-1.aspxyou 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.Wed, 09 Mar 2011 12:43:25 GMTChazManhttp://www.sqlservercentral.com/Forums/Topic1075817-391-1.aspxHello,Tracing a process in Profiler, but, I found for an event:SP:StmtStarting in the EventClassValid SQL stmt exists in the TextDataHowever, 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.Wed, 09 Mar 2011 12:35:02 GMTmymail.default