"Patrick" <cparker@home.com> wrote in message
news:OVJ1fiPuGHA.2148@TK2MSFTNGP02.phx.gbl...
> Hello all!
> Can one dev help another? Is there any way to get the column schema from
> a stored procedure without calling it with parameters in slq server 2000?
> I just want to know the columns it returns.
>
> Many thanks,
> Sincerely,
> Patrick
>

"Tom Cooper" <tom.no.spam.please.cooper@comcast.net> wrote in message
news:I_ydnQSWn7c1zEjZnZ2dnUVZ_vydnZ2d@comcast.com...
> No, you either have to look at the code of the stored proc or run the
> stored proc. It would be very difficult to write a generalized piece of
> code to examine a stored proc and return all possible results because
> stored procs can do almost anything. Like return multiple result sets or
> return different result sets depending on various factors. For example,
> the following will return a different set of columns in its result set
> depending on the time of day you run it.
>
> Use pubs
> go
> Create Procedure VeryBadProc As
> If DatePart(hour,GetDate()) >= 12
> Select * from sysobjects
> Else
> Select * From syscolumns
> go
> exec VeryBadProc
> Drop Procedure VeryBadProc
>
> Tom
>
> "Patrick" <cparker@home.com> wrote in message
> news:OVJ1fiPuGHA.2148@TK2MSFTNGP02.phx.gbl...
>> Hello all!
>> Can one dev help another? Is there any way to get the column schema from
>> a stored procedure without calling it with parameters in slq server 2000?
>> I just want to know the columns it returns.
>>
>> Many thanks,
>> Sincerely,
>> Patrick
>>
>
>