Meta Data

23 Mar 2005 4:17 PM

Kayode Yusuf

Greetings -

Can somebody please help me out with retrieving Meta Data dynamically for a
Stored Procedure.

I know I can use SET FRMONLY ON to retrieve it - but this return a Header
info. What I want is a resultset containing that META Data that can be
inserted or used in a SELECT statement fo further manipulations.

TIA.

KOY

23 Mar 2005 4:22 PM

Armando Prato

See my response in microsoft.public.sqlserver.programming

Show quoteHide quote

"Kayode Yusuf" <KayodeYu***@discussions.microsoft.com> wrote in message
news:92EF08FB-0675-4B90-9563-E29482987018@microsoft.com...
> Greetings -
>
> Can somebody please help me out with retrieving Meta Data dynamically for
a
> Stored Procedure.
>
> I know I can use SET FRMONLY ON to retrieve it - but this return a Header
> info. What I want is a resultset containing that META Data that can be
> inserted or used in a SELECT statement fo further manipulations.
>
> TIA.
>
> KOY

23 Mar 2005 5:03 PM

Kayode Yusuf

For starters, Tanx for the post. WHat needs to be done is process the
ResultSet in TSQL as done through an API.

If you make call a Call to SQLServer throughan API with SET FMTON - it
executes
the procedure and returns a zero lenght resultselt - the META Data - you can
then through the API - iterate through th ResultSet Column names to find out
the META data for the procedure.

Essentially, I want to achive the Same in TSQL mode - I need to get the META
data of a Stored procedure and be able to identify the Columns returned by
the call using SET FMTONL directive.

TIA,

KOY

Show quoteHide quote

"Armando Prato" wrote:

> See my response in microsoft.public.sqlserver.programming
>
>
> "Kayode Yusuf" <KayodeYu***@discussions.microsoft.com> wrote in message
> news:92EF08FB-0675-4B90-9563-E29482987018@microsoft.com...
> > Greetings -
> >
> > Can somebody please help me out with retrieving Meta Data dynamically for
> a
> > Stored Procedure.
> >
> > I know I can use SET FRMONLY ON to retrieve it - but this return a Header
> > info. What I want is a resultset containing that META Data that can be
> > inserted or used in a SELECT statement fo further manipulations.
> >
> > TIA.
> >
> > KOY
>
>
>