Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-11-03 : 07:46:45
|
| raj writes "In a particular scenario I need to find out what all input parameters of the stored procedure are mandatory(don't have default values).I tried searching all system tables.The table syscolumns provides the paramter information but doesnt specify whether the parameter is mandatory or has some default value.Any help would be very kind indeed!Thanks." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-11-03 : 07:47:32
|
| You would have to look at the source code of the procedure in order to determine this. |
 |
|
|
|
|
|
How to find out mandatory parameters in a Stored Proc.