how to trace a given t-sql-statement?

[Database Administrator]

hi,

in order to troubleshoot a given scenario i have to find out, which stored
procedure, etc. is firing as a specific piece of t-sql code (which has been
written by different people). how can i figure this out? i am aware of sql
profiler, but in case this is the right tool, what to to do in detail/which
event is to monitor and how can i trace only, if the given t-sql statement
is fired assuming tons of t-sqls are fired a day?

or - if sql profiler is the wrong tool - here, how to proceed instead?

--
thanks in advance / danke im voraus - fritz

Fritz Theiss

[Database Administrator]

Fritz Theiss (fritz@anywhere.com) writes:
> in order to troubleshoot a given scenario i have to find out, which
> stored procedure, etc. is firing as a specific piece of t-sql code
> (which has been written by different people). how can i figure this out?
> i am aware of sql profiler, but in case this is the right tool, what to
> to do in detail/which event is to monitor and how can i trace only, if
> the given t-sql statement is fired assuming tons of t-sqls are fired a
> day?

You could set up a filter on TextData that includes some text from this
piece of code. Assuming that you know what code you are looking for
that is.

It could help if you describe you scenario in little more detail. Is this
T-SQL code a SELECT or an update action?


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx