Executing Master Stored Procedures

[Jim Heavey]

I am going to run of the "Master" stored procedures, say
"sp_sproc_Columns". It has a parameter with a datatype of "sysname". What
exactly do I map this column to in the SqldbType?

If some parms are set up in the procedure as accepting nulls, do I have to
create an entry in the command.Parameter collection for these parms if I do
not plan to pass any values?

Thanks in advance for your assistance!!!!!!!!

 

[IbrahimMalluf]

heh

as your command text try "Exec sp_sproc_columns
@procedure_name='sp_sproc_columns'"
that should answer your second question

I did not find sysname as a parametor type of sp_sproc_columns Only
nvarchars and int



--
Ibrahim Malluf
http://www.malluf.com
==============================================
MCS Data Services Code Generator
http://64.78.34.175/mcsnet/DSCG/Announcement.aspx
==============================================

 

[Miha Markic]

Hi Jim,

Try with NVarChar with size 128.