It's been a while since I used profiler, but I think RPC:Completed and SQL:BatchCompleted should do the trick.

Scenarios for Using SQL Server Profiler

Rachel Byford (2/7/2012)

---

Have you checked that this is the only error you're getting?

I've discovered that it's quite common to get this error AFTER you've had a real SQL error (e.g....

Khades (2/7/2012)

---

Koen Verbeeck (2/7/2012)

---

Khades (2/6/2012)

---

I have a name column coming from my source. I need to get the ID for each name. The table in which the name and ID...

MysteryJimbo (2/7/2012)

---

Koen Verbeeck (2/7/2012)

---

What is the recovery model of your database?

With such a huge query involving so much data, there will be quite some logging overhead. So minimize the logging...

Steve Jones - SSC Editor (2/7/2012)

---

Koen Verbeeck (2/7/2012)

---

A bit back on-topic:

http://www.sqlservercentral.com/Forums/Topic1247840-364-1.aspx

Not really a worse question, but a weird one. (read all the way to the bottom)

What would justify such a...

You have already specified at least two different sequences + the following quote:

Here the...

What did you expect? You ask for a...

Did you notice the question marks in my previous reply? It means that I have asked...

So the table Code_Desc and XYZ have no relation at all, but you still want to join them together? That seems a little odd.

And first you said you had hundreds...

Allright, two people now (Lynn and I) asked for DDL, sample data and desired output.

As long as you...

simhadriraju (2/7/2012)

---

As i said intially in my requirement i have hundreds of select queries which produces hundreds of result sets i want to store them in a variables so...

simhadriraju (2/7/2012)

---

Here my assumption in the result set is

Resultset1+(DT_STR,12,1252)RecordNumber + Amount1 + Amount2 +

Resultset2+Resultset3 .....

in the above sequence order of the columns might changed in future when...

SSIS Package Configurations

This is not the same as:

simhadriraju (2/7/2012)

---

Resultset1+(DT_STR,12,1252)RecordNumber + Amount1 + Amount2 +

Resultset2+Resultset3 ........

That makes a bit more sense.

The problem here is generalizing it. Since every table has a different column name, this is quite...