This UDF will help you

Hello everybody,

I recently had a similar issue. In fact the error message is not properly formatted since sp_executesql is an extended stored procedure as you can check by the following script:
select objectproperty( object_id('sp_e xecutesql'),'Is ExtendedProc')
returns
1
Since we can’t use sp_executesql even it’s a XP, I had to found another workaround by using...