May 9, 2002 at 9:15 pm
Hi Everybody,
I need to get the default values of Parameters of a Stored Procedure from an XML File. Can anybody guide me as I've searched all system tables and i've found the other attributes of stored procedure and its parameters but not this one.
Regards
Deepa
Deepa
Deepa
May 9, 2002 at 9:41 pm
May 9, 2002 at 10:37 pm
Check syscomments - it has description of the proc. in the text column, you may parse the values to retrieve the defaults
May 10, 2002 at 5:20 am
Epol is right as even though the Parameter names are stored in syscolumns the defaults are not stored with them. The only place is syscomments to find them.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 10, 2002 at 12:08 pm
I posted a script for retrieving default for parameters in stored procedure.
May be you can use it for your purpose;
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=333
May 14, 2002 at 9:33 pm
Thanks a ton,
Regards
Deepa
Deepa
Deepa
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply