Information_Schema.Routine_Columns returns 0 rows

[SBendBuckeye]

Hello All,

Am I missing something obvious here. I have run other Information_Schema views with no problem. sp_sproc_columns works also but anything I try with Routine_Columns returns 0 rows. Any ideas and/or suggestions? Thanks!

Have a great day!

j2consulting@yahoo.com

 

[vongrunt]

Routine_Columns returns columns only for table-valued function s (UDF).

The same is not possible for stored procs for obvious reasons - procedural code.

------
[small]select stuff(stuff(replicate('<P> <B> ', 14), 109, 0, '<.'), 112, 0, '/')[/small]