> >If not, is there any other reason a UDF
> > shouldn't be used instead of a sproc (I'd rather use a sproc,

since

> > their easier to maintain, but some things need to or should be

done

> > in C/C++)?
>
> External Functions should call back into the database. Plain and
> simple.

Should? I read that external functions which call back into the
database (by necessity inside a separate transaction) could
potentially cause deadlock.

Is it correct to say that UDF's must call back into the database
(because they cannot use the current transaction context), but
should not (potential deadlock)?

Sorry for all the n00b questions, and thanks to everyone for your
help!

thanks,
--craig