Hi John,
The short version is that we were planning a type of process to send
stored proc calls to a table in our database that are "process heavy"
and take a while to execute.  A SQL job was going to pick them up and
actually run them.  So we were sending the proc name, and info on the
parameters to the web service which would then insert that info into a
table that the SQL job would read and then execute accordingly.  Thus
I need an array of some kind that users of the web service can shoot
me off their parameter info.

But, since I posted the question, the design was put on hold.  Seems
they want to wait until we get SQL 2005 completely installed on all
our sql servers first.

Thanks though for the input!