Unfortunately, it means exactly what it sais - that you cannot execute
anything from within a UDF except an *extended* stored procedure or
another UDF.

Since sp_executesql is not an extended stored procedure it will not
work. You will need to execute your sp_executesql statement within a
stored procedure instead. Good luck!

Dadou.

thomson wrote:
> Hi all,
> Can sp_executesql used inside a user defined function, i
> tried but it has compiled well, but when i call the functio it shows
> Only functions and extended stored procedures can be executed from
> within a function.
>
> What i have went wrong
>
> Thanks in advance
>
> thomson