July 29, 2002 at 9:16 am
In some of the traces I have set up, I am constantly seeing this sp_execute being fired, however I can not find you more information other that it is an XP. What is it for and why can't I find it in the master databases stored procedures.
Any further definition of this procedure would be greatly appreciated.
thx to all
July 29, 2002 at 10:27 am
same as exec().
runs the SQL statement passed as a parameter.
Steve Jones
July 29, 2002 at 11:28 am
Thanks for the response Steve, however I'm not sure you answered my question, or I am just not smart enough to understand 🙂 I'm not seeing the sp_execute and then a procedure or sql statement after it. I am seeing something like this: sp_execute 18, ' ', ' '. I'm trying to figure out what this sp_execute is doing.
thanks for all your help
same as exec().
runs the SQL statement passed as a parameter.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
[/quote]
July 29, 2002 at 11:54 am
I believe this is how many ADO connections work. They "prepare" a statement on the server and execute it with sp_Executesql.
What are the front end connections?
Steve Jones
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply