Can I programmatically change/add a stored procedure at runtime

[johnatwork]

I've seen examples of how to programmatically add or change a table at runtime w/ RAS 9 object model, but not a SQL Server stored procedure. Is it possible?

I'd like to change the stored procedure used at runtime, like you would do with Database/Set Datasource Location within the Crystal designer.

If it's not possible with RAS 9, is it possible with RDC object model?