Glenn,
Sounds like you may be better served having another schema for your in-progress stored proc. I haven't done this personally, but have had it explained to me and it sounds like it would fit your situation.


>The development team is "phasing" in a new stored procedure. It currently is being tested with a different name. In the class which calls this SP we need to check which version is being called so that we don't break a web application. The new SP will have two new parameters so the class which calls this SP can test the number of parameters. At some point the new one will replace the old one and we do not want to replace the other components.
>
>BTW this is the technique I cam up with to test the number of parameters thanks to the 4guys at Rolla.com
>
>
>

>Dim myCommand As New SqlCommand
>myCommand.Connection = myConnection
>myCommand.CommandText = stored procedure name
>myCommand.CommandType = Data.CommandType.StoredProcedure
>
>myConnection.Open()
>SqlCommandBuilder.DeriveParameters(myCommand)
>myConnection.Close()
>dim PCount as integer = myCommand.Parameters.count
>

>
>
>
>>>Before calling a StoreProcedure is there any way to know how many parameters are required ?
>>
>>Isn't there an API? Or do the calls vary for some reason?