>Nope....the "execute" is implied.
>
>>Should it be: SQLEXEC(nConn,"execute sp_whatever") ?
>>
>>>Hmmm, Mark
>>>
>>>I mean, it's pretty clear cut. I've used SQLEXEC(nConn,"sp_whatever") many times. Are you sure you have a good connection and a good proc name?
>>>
>>>>Does not work. SQLEXEC does not recognize sp name and returns -1.
>>>>Mark
If it is a user defined stored procedure, make sure that the procedure has been granted to all users, if not, it won't be visible to anyone... And with respect to "EXEC sp_name", it was required for me just for purpose of using "sp_helpindexes" which is a system stored procedure.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement