ADO & Stored Procedure & SQL Server

From: Enrico Matta (e.matta_at_libero.it)
Date: 01/23/05


Date: Sun, 23 Jan 2005 02:38:10 +0100

with a multiple execution of a sql server stored procedure (SQLOLEDB) with a
command object i get with the profiler this instruction:
SET FMTONLY ON EXEC dbo.pAttivita_Elenco_Update_1 0,0 SET FMTONLY OFF

for example with this code:

 set cmd = Server.CreateObject("ADODB.Command")
 set cmd.ActiveConnection = con
 cmd.CommandText = "dbo.pAttivita_Elenco_Update_1"
 cmd.CommandType = &H0004

 cmd.Parameters.Append cmd.CreateParameter("Par1",3,,,10)
 cmd.Parameters.Append cmd.CreateParameter("Par2",3,,,10)
 cmd.execute

 cmd.Parameters.Append cmd.CreateParameter("Par1",3,,,20)
 cmd.Parameters.Append cmd.CreateParameter("Par2",3,,,20)
 cmd.execute

and i don't get it with only one execution

why?