I just registered a SQL Server view with ArcSDE through
sdetable -o register [...].
I wonder, how to register a SQL Server stored procedure with ArcSDE? Is it the same process as the view?
It seems that to register a stored procedure, it is required to have a "stable" database object: the definition of the stored procedure by itself it is just a piece of code that has no sense until it is executed with some input parameters.
Ok, so, if we consider the stored procedure as a "data collection generator", how would you execute this code with the input parameters, catch the tabular data output and register it to ArcSDE? What would you use? Some kind of ArcGIS processing?
Please, could you provide any example or guidelines for this process?