Parameter Default Values

[jafisher2000]

Hi
Does anyone know if one can retrieve the parameter default values specified in a stored procedure creation statement. I get the parameter columns of the stored procedure <xproc>
by executing sp_stored_proc_columns <xproc>. The rows returned does not indicate whether the column is required.

 

[jafisher2000]

I can't beleive there is no one out there with this information !

 

[dky1e]

check out the INFORMATION_SCHEMA.ROUTINE_COLUMNS view.

 

[dky1e]

Interestng... It will actually give you the column data for functions, no sp's.

Let me take a look.