title: How can I determine if a SQL Server stored procedure parameter has a default?
body: <p>Is there a way to determine programmatically if a SQL Server stored procedure parameter has a default?  (Bonus points if you can determine what the default is.)  <a href="http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommandbuilder.deriveparameters.aspx" rel="noreferrer">SqlCommandBuilder.DeriveParameters()</a> doesn't even try.</p>
  
  <p>Thanks in advance for your help!</p>
  
  <p>EDIT: I honestly don't care if it's a SQL Query, an SMO object, etc.</p>