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.
>