Is there any way to access the default value of a stored procedure parameter, if it has any?
ColumnSchema and ParameterSchema both derive from DataObjectBase, and expose the ExtendedProperties collection, which in the case of columns, contains a property CS_Default that contains the column's default value. But, I find that extended properties for a parameter object contain a CS_Default property, but the value is never set, even for parameters with defaults.
Is this a known problem or is there some other way to get this info?
Thanks