SQL Server Profiler - View Dynamic Sql

views:

answers:

+1 Q:

SQL Server Profiler - View Dynamic Sql

Hi All,

I am building and executing some dynamic sql and wanted to use SQL Server profiler to view that execution statement. Do you know what filters /settings I have to use in order to see that? I have looked through them and could be just looking right over the obvious setting.

EDIT:

The dynamic sql is called within a procedure.

Thanks in Advance,

--S

Take a look at the SQL:BatchCompleted event in the TSQL category and make sure you have the TextData column checked/shown. The Standard (default) template includes these already.

Daniel Renshaw 2010-09-01 15:43:28

Thanks Daniel the dynamic sql is called within a procedure. Does that change the config?

scarpacci 2010-09-01 16:00:12

I'm not sure; it might work if you're `sp_executesql` or `EXEC` ing some SQL but if it doesn't try turning on the `SQL:StmtCompleted` event too.

Daniel Renshaw 2010-09-01 16:06:36

+1 A:

Following your edit you would need either the SP:StmtCompleted or SP:StmtStarting events (You can find these in the "Stored Procedures" section).

This might collect quite a lot of data so apply appropriate filters.

Martin Smith 2010-09-01 16:05:30

that did it thanks

scarpacci 2010-09-01 16:17:39

ansaurus

tags:

views:

answers:

SQL Server Profiler - View Dynamic Sql

related questions