I know is possible I just forgot how. Thanks.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.
>|||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.
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment