Are SProc parameters stored in a system (2005) table!

microsoft.public.sqlserver.programming

7 Sep 2006 10:23 PM

Mark In Atlanta

When a stored procedure is created or when it compiles are the parameters
saved in a table separate from the SProc text. I'd like to query them.

Thanks

7 Sep 2006 10:32 PM

Tom Cooper

They are in the sys.all_parameters view.

Tom

Show quote

"Mark In Atlanta" <MarkInAtla***@discussions.microsoft.com> wrote in message
news:7A8AB61A-5D51-42D0-999D-0DD2335BA064@microsoft.com...
> When a stored procedure is created or when it compiles are the parameters
> saved in a table separate from the SProc text. I'd like to query them.
>
> Thanks

7 Sep 2006 10:45 PM

Mark In Atlanta

Wonderful!

Thanks Tom

Show quote

"Tom Cooper" wrote:

> They are in the sys.all_parameters view.
>
> Tom
>
> "Mark In Atlanta" <MarkInAtla***@discussions.microsoft.com> wrote in message
> news:7A8AB61A-5D51-42D0-999D-0DD2335BA064@microsoft.com...
> > When a stored procedure is created or when it compiles are the parameters
> > saved in a table separate from the SProc text. I'd like to query them.
> >
> > Thanks
>
>
>