Does anyone know of a resource that discusses the advantages of using the command object to execute a stored procedure verus constructing a string of the stored procedure call and using Execute. I have both methods working, so I do not help in this area, I simply want to know the advantages of using one over the other.<BR><BR>Thanks<BR><BR>--&#062;ADO<BR>Set cmd1 = server.CreateObject("ADODB.Command")<BR>cmd1.Activ eConnection = objConn<BR>cmd1.CommandType = adCmdStoredProc<BR>cmd1.CommandText = "ps_Test_INSERT"<BR>cmd1.Parameters.Append cmd1.CreateParameter("strUserName",adVarChar,adPar amInput,30,strUserName)<BR><BR>Versus<BR><BR>--&#062;String/Execute<BR>sSQL = "ps_Test_INSERT " & StrUserName<BR>SQLConn.Execute(sSQL)<BR><BR>