Figure Out the Default Value of Stored Procedure Parameters

Code sample, something not very complex, I find it usefull, at least to know that it is possible to do it :-)

In this article you will see how you can derive all parameters from a Stored
Procedure using some T-SQL and C# code so that you can call your stored
procedures and automatically have the default parameters assigned with their
default value.

http://www.codeproject.com/useritems/FindDefaultValueSPParams.asp