I cannot find any documents to confirm this so if someone could confirm the below it would be appreciated.
sp_execute and sp_executesql do the same thing but sp_execute is an older version of sp_executesql.
I have an application where they claim they are sql2000 sp4 compatible yet they use sp_execute opposed to sp_executesql.
Should they not be using sp_exectutesql opposed to sp_execute ??
Please help me understand the differences or a link where it is documented.