How to determine which input parameter in a Stored procedure is optional (means have a defaullt value, could be NULL) in SQL 2005
I can get other information FROM INFORMATION_SCHEMA.PARAMETERS
and there is a view sys.all_parameters which has field called has_default_value but seems to be incorrect.
Anyone with any other info ??