|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
31/03/2008, 20h25
|
#1 |
Messages: n/a
Hébergeur: |
capture udf calls in trace
I know is possible I just forgot how. Thanks.
|
|
|
31/03/2008, 20h42
|
#2 |
|
Messages: n/a
Hébergeur: |
Re: capture udf calls in trace
SP:Completed will fire once for every execution of a UDF. If you have a
query that processes 10K rows with a UDF you will get 10K events so use it wisely. -- Andrew J. Kelly SQL MVP Solid Quality Mentors <a> wrote in message news:u7Qzny1kIHA.3780@TK2MSFTNGP06.phx.gbl... >I know is possible I just forgot how. Thanks. > |
|
|
|
31/03/2008, 21h00
|
#3 |
|
Messages: n/a
Hébergeur: |
Re: capture udf calls in trace
Thank you.
"Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message news:OwmCE81kIHA.4684@TK2MSFTNGP06.phx.gbl... > SP:Completed will fire once for every execution of a UDF. If you have a > query that processes 10K rows with a UDF you will get 10K events so use > it wisely. > > -- > Andrew J. Kelly SQL MVP > Solid Quality Mentors > > > <a> wrote in message news:u7Qzny1kIHA.3780@TK2MSFTNGP06.phx.gbl... >>I know is possible I just forgot how. Thanks. >> > |
|
|
 |
| Outils de la discussion | |
|
|
