I wish I had an answer for you Jaeden, but I ran into the same problem trying to call a table-valued function with a defaulted parameter. I don't even have the option of "not including the parameter to default it" because calling a
TVF requires the explicit placement of the keyword DEFAULT in the function call syntax: select * from fn_sample(123, DEFAULT); I think the DBDefault suggestion ...