I have a sql statement in an ASP page which runs a stored procedure..i need to return the output parameters of the stored procedure, to the asp page, but how? if i run the exact same statement in QueryAnalyzer it returns the Output parameter..here is the statement:-<BR><BR>sql= "Declare @ret int "<BR>sql = sql & "Exec @ret = sp_storenewlead &#039"& session("LogId") &"&#039, &#039"&contid&"&#039,&#039"& session("details") &"&#039 "<BR>sql = sql & "Select &#039ReturnStatus&#039=@ret "<BR><BR>Set rs = Server.CreateOject("ADODB.Recordset")<BR>rs.Open sql, conn, 3, 3<BR><BR>